importing rows to cols
 

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?

importing rows to cols
 

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?

importing rows to cols
 

Thanks for quick reply. Unfortunately Paste Special is grayed out so I can't
select it.

"JudithJubilee" wrote:

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?