change data in rows to be viewed in 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?

Chet

Select A1:A20 and copy.

Then Select B1 and EditPaste SpecialTransposeOKEsc.

Note: you cannot copy to A1 because it is part of the original range.

Delete Column A.


Gord Dibben Excel MVP

On Thu, 10 Mar 2005 10:53: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?