Hello,

I am asking this question on behalf of my father. He has a spreadsheet of
data which is about 2000 rows long and 9 columns wide. My dad wants to
transpose the data in columns B - I in the following manner:

The data in B1 will move into cell A2 (and the data in A2 will move down to
A3). The data in C1 will move into cell A3 (and the data in A3 will move
down to A4).
And so on until I1 becomes A9 and the data in A9 moves over to A10.
This happens row after row - i.e., B2 becomes A11; C2 A12, etc. for all
2,000 rows.

Any ideas how this can be down?

Thanks and be well,

Moshe