software

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?

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 helpsquot;Milcoquot; wrote:

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

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

quot;JudithJubileequot; wrote:

gt; Hello Milco,
gt;
gt; Highlight you cells and press Ctrl X (Cut). Right click A1 and choose
gt; Paste Special. Check the Transpose button and OK.
gt;
gt; Judith
gt; --
gt; Hope this helps
gt;
gt;
gt; quot;Milcoquot; wrote:
gt;
gt; gt; I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A
gt; gt; to IV. Obviously I have run out of columns and will switch to rows. How do
gt; gt; I import row 1 to col A and row 2 to col B?