ROW TO COLUMNS

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

Guest

I CAN VIEW TEXT FROM A FORM ON MY WEBSITE IN EXCEL, HOWEVER, THAT DATA FROM
THE FORM IS IN THE FIRST COLUMN. (A1-A20) i NEED TO VIEW THE DATA ACROSS THE
TOP OF MY WORKSHEET IN THE COLUMS. I NEED THE DATA VIEWED IN A2 TO BE VIEWED
IN B2, A3 IN C1, A4 IN D..etc. i WILL BE ABLE TO USE THE AUTO FILTER FEATURE
THEN. hOW CAN I DO THIS?
 
Highlight your column of data and Copy. Place the cell pointer in A1 and
select Paste Special and tick the Transpose box in the options box that
opens. Click OK.

Your data is now in Row 1 columns A-??

HTH
 
Chet

A couple of suggestions if you're going to be around here a while.

Do not post in ALL CAPS. Hard to read and considered "shouting".

Wait a little longer for a reply to a post. I just wasted my time answering
your first post with a duplicate answer to the one swat gave to this second
post.


Thanks, Gord Dibben Excel MVP
 
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

change data in rows to be viewed in columns 1
copy only the 1st, 7th, 13th, 19th, 25th.....row only 6
How can I move data from a row range to a column range 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
mapping? columns from one excel workbook to another 1
entire column to comma delimited cell 2
Transposing columns to rows 3
Filtering of data in a master excel sheet from multiple sheets 3

Back
Top