How do you change the rows to columns and columns to rows.

C

cc4digital

Ok, I am stumped on how to do this?
I have a spreadsheed that has Dates in the A column and Data in the
row. I want to make is so, the data is in the A column and Dates ru
accross in the 1 column. How can I do this?

Sound easy, but I am stumped??? :eek
 
D

Dave O

Highlight your data and copy it into the clipboard. Move to an open
spot in the spreadsheet and click >Edit >Paste Special, then select the
Transpose box and click OK. It takes a little getting used to, but
should do what you need.
 

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

Top