Move data in rows to columns

[hfler]

Hello--

I just imported a ton of data from an internet website into excel. I want the data to be organized in columns, such as 'company name,' 'contact', 'company description'. However, all of this data is organized into rows instead of columns. How do I convert that data so that, for instance, every third row goes into a column entitled company name, every second row into a column called 'contact', etc.

If anyone has any insight into this, it would be greatly appreciated.

Thanks.

[oldchippy]

Hi,

If you want it split into three columns try this,

B1 =IF(MOD(ROW()-ROW($A$1),3)=0,A1,"")

C1=IF(MOD(ROW()-ROW($A$1),3)=0,A2,"")

D1=IF(MOD(ROW()-ROW($A$1),3)=0,A3,"")

Select B1:D1 and copy down to the entire length of column A, then copy, paste special values, and sort in accending order to remove the blanks

[MickG]

Hi, hfler
Try copying you data, open a new sheet, Select "A2", Right click,Select Paste special, Click "Transpose",Click Ok.
Place you Headers in Row (1)
You might have to play with it a Bit !!
Regards Mick