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!
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