I didn't see any reply to this David. You can send me the file and I'll see what I can do if you are still in a pickle?

Regards Robert

"dhooie " wrote in message ...
First of all, thanks up front for any help.

I am a simple Excel user who desperately needs to convert a single
column of data that I imported from a text file that has several rows
into multiple columns.

i.e: My data looks like this:

SMITH
Pentium II
400
128MB
JONES
Celeron
1000
256MB
RICHARDSON
Pentium 4
2200
1028

I'd like to convert it to this:

SMITH Pentium II 400 128MB
JONES Celeron 1000 256MB
RICHARDSON Pentium 4 2200 1028MB

There are several rows of data all pretty much grouped that way. Some
"groups" have extra rows of info, like serial # etc. What I'd like to
do is convert all the groups to a single row of data over multiple
columns and then shift all the new rows so that their respective
"fields" line up in the same column, but I can do that last part
manually.

What I really need to save me some time is a macro of some kind to get
this single column of data into the format like I've shown above.

Also, I know NOTHING about Macros. (I'm not even sure I know how to
run one.) so please be gentle in your explanations and use little words
with as few syllables as possible.

Thanks so much in advance!

David Hooie


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 21/02/2004