I have data organized in 3 columns as follows: ID, Date, Value with variable numbers of dates and corresponding Values for each ID. I have attached an excerpt in the worksheet.
I need it to look like this:
ID1, Date1, Date 2, Date 3, Value 1, Value 2, Value 3
ID2, Date 1, Date 2, Value 1, Value 2
ID3, Date1, Date 2, Date 3, Date 4, Date 5, Value 1, Value 2, Value 3, Value 4, Value 5
and so forth. All Date 1s should start in the same column, same with Value 1.
While I could do this manually with transpose function there are over 4000 rows. Any help would be appreciated. Thanks!