I want to combine rows with the same ID from a "long" data set into a "wide" data set based on common ID numbers. File is currently in excel format. Some IDs may have only 1 row, but others have up to 30 rows. There are 5 variables per row (including the ID number). Thanks! Data have: ID Num Date Result Type 1 1 1/1/2013 words 1 2 10 1/10/2013 words 3 2 2 6/1/2014 words 4 2 5 7/1/2015 words 2 3 23 3/1/2014 words 1 3 4 6/2/2015 words 2 4 2 4/1/2013 words 1 Data want (with var going up to Num30, Date30, Result30, Type30) ID Num1 Date1 Result1 Type1 Num2 Date2 Result2 Type2 Num3 Date3 Result3 Type3 1 1 1/1/2013 words 1 2 10 1/10/2013 words 3 2 6/1/2014 words 4 5 7/1/2015 words 2 3 23 3/1/2014 words 1 4 6/2/2015 words 2 4 2 4/1/2013 words 1
... View more