ROW TO COLUMNS
 

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

On Thu, 10 Mar 2005 10:57:02 -0800, "CHET"
wrote:

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?