Hello Milco,

Highlight you cells and press Ctrl + X (Cut). Right click A1 and choose
Paste Special. Check the Transpose button and OK.

Judith
--
Hope this helps


"Milco" wrote:

I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A
to IV. Obviously I have run out of columns and will switch to rows. How do
I import row 1 to col A and row 2 to col B?