Greetings,
I need to rearrange my data somehow so that they line up in two columns with values from oldest down to newest. The data are dated and each date may have multiple values in corresponding rows. Which is the most efficient way to line up the dates with each value in sequential order down two columns?
In the sheet example, rows 5 through 8 are dated and each row has several values listed horizontally for each date. How can they be rearranged so that they line up as shown in column W and X?
Bookmarks