Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can't work this one out can you rotate the data in a spread sheet

Colloms to rows ie
From:
Name
Adress
Town
Post code

To
Name Address Town Post code

Eash item is in a single cell

Help!!
 
Yes you can. Copy the information then right click and paste specia
and click transpose
 
You must log in or register to reply here.

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

Macro to work list in filter and save 1
question 1
Pivot Table Subtotals 1
DB4 imported data 3
Imported text separation problem 2
using part of a cell to sort a list into groups 2
MOVE SPECIFIC INFORMATION TO ANOTHER SHEET 1
Separating data to put in seperate cells 5

Back
Top