Monday, 27 May 2013

Excel rearrange data and sort

Excel rearrange data and sort

i have a table in excel with data in this format (with alot more data):
date source data1 data2
1.2.3   1   767     888
1.2.3   2   543     444
2.2.3   1   557     333
2.2.3   3   576     777
It is a few thousand lines of data and 6 sources, a different number of dates with data for every source. I need to use some sort of excel magic to arrange the data like this:
date source data1 data2  source data1 data2  source . . .
1.2.3   1   767     888     2   543     444     3
2.2.3   1   557     333 
.
.
.  
So that the sources come after eatchother horizontally and arranged by date. Any ideas on how i could rearrange and sort the data like that?
Thank you for the help!

No comments:

Post a Comment