I have data that exports from a database with the following format and I need to format the data to the desired transposed data format.
How do I accomplish this? The data is only a snippet of the data.
Date Time Value
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56
4/20/2013 7:05:00 126
4/21/2013 9:09:00 77
4/21/2013 12:09:00 75
4/22/2013 14:12:00 105
Desired result after transpose
Date Time1 Value1 Time2 Value2 Time3 Value3
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56 7:05:00 126
4/21/2013 9:09:00 77 12:09:00 75
4/22/2013 14:12:00 105
How do I accomplish this? The data is only a snippet of the data.
Date Time Value
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56
4/20/2013 7:05:00 126
4/21/2013 9:09:00 77
4/21/2013 12:09:00 75
4/22/2013 14:12:00 105
Desired result after transpose
Date Time1 Value1 Time2 Value2 Time3 Value3
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56 7:05:00 126
4/21/2013 9:09:00 77 12:09:00 75
4/22/2013 14:12:00 105