I have 180 columns containing the same character data reported each year over many years (from a longitudinal data set).   I am looking to combine these columns into one singular column so that I can compute two way frequencies etc.   I have looked into "append" however I understand this is for datasets not variables.  I have also tried a transpose, however I end up with 9000 columns (number of patients).  Other similar posts suggest an array for this type of data, however they all require you to enter datelines.  My dataset is much too large to record  each individual dateline!   Hope someone has insight as to how to do this, or possibly a better method!    Current Data:  Patient ID      Year 1.    Year 2.    Year 3.    Year 4.   Year 5 1.                    ABC         ABB        ABA        ABC      BAC   2                     ACA         ABC        ABB        ABA      AAC   3                     ABB         ABA        ACA        ABC      AAC     What I want:  Patient ID   Health Condition 1.                    ABC         1.                    ABB       1.                    ABA         1.                    ABC       1.                    BAC   2.                    ACA         2.                    ABC         2.                    ABB         2.                    ABA       2.                    AAC   3.                    ABB 3.                    ABA         3.                    ACA         3.                    ABC       3.                    AAC     ... View more