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.
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
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks