importing rows to cols

G

Guest

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?
 
G

Guest

Hello Milco,

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

Judith
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function returning SUM of 2 adjacent cols in 2 separate cells 7
Excel spreadsheet to Word document 1
INDEX return multiple columns 1
return unique data from a list 4
conditional format of entire row based on a single cell in row 7
2 formulas needed same workbook 15
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula printing in cell 6

Top