Hi
Scott,
Yes, you can definitely
reverse transpose an array of data in Excel. Here's how you can do it:
- Select the cells that contain the data you want to reverse transpose.
- Copy the data by pressing or right-clicking and selecting "Copy".
- Select the cell where you want to paste the transposed data.
- Right-click and select "Paste Special".
- In the "Paste Special" dialog box, check the "Transpose" box.
- Click "OK".
This will transpose the data, but in the opposite order. So in your example, the row of date headers will be transposed into a column, but in reverse order.
To get the order you want, you can simply copy the transposed data and paste it into a new location. Then, select the pasted data and use the
"Sort" function to sort it in ascending order. This will give you the data in the order you want.