This may seem like a basic question, but I am trying to transpose data in a column so that it formats horizontally in a row (without using the copy paste special function because I want this to be a constantly automated format). The caveat is that I want to skip every other row in the initial columns. In other words, the final result should be single rows of data that populate data from every other row in the initial columns. For example, the initial format...
Column A Column B Column C
2/2/2015 1 50
2/2/2015 2 100
2/3/2015 3 150
2/3/2015 4 200
2/4/2015 5 250
2/4/2015 6 300
2/5/2015 7 350
2/5/2015 8 400
...should ultimately look like this...
Column D Column E Column F Column G
2/2/2015 2/3/2015 2/4/2015 2/5/2015
1 3 5 7
2 4 6 8
50 150 250 350
100 200 300 400
Any help would be greatly appreciated. Thanks!
Bookmarks