converting a list to columns...

Posted by Laura on October 08, 2001 7:34 AM

Hi all-
I have a list of data that I imported from a text file into Excel. The only problem is that the list should be in 8 columns instead of one. It now reads:
a
b
c
d
a
b
c
d
It should read:
a b c d
a b c c.

Any suggestions for a macro I could use?

Thanks in advance,
Laura

Posted by Dan Aragon on October 08, 2001 12:01 PM

I'm confused. This way that you have the columns listed would be 4 columns, not 8 as you wrote. If you just want a macro that transposes rows to columns, then try pasting the data on one sheet in a single column, highlight the data and Copy. Then go to another sheet, highlight the first cell of the row, select Paste Special, click on Transpose. I don't know if that's what you are looking for. Reply if you need more help and clarification.

Posted by Eric on October 08, 2001 12:03 PM

hope this helps until the script writers can address this

if your data starts in A1, then in B1 enter
=INDIRECT("a"&COLUMN()-1)

and in b2 enter
=INDIRECT("a"&COLUMN()+3)

copy across as far as you need,
HTH