List to table

Hi!

I have a list in this format:

entry 1
entry 2
entry 3
entry 4
entry 5


entry 6
entry 7
entry 8
entry 9
entry 10


entry 11
entry 12
entry 13
entry 14
entry 15

and want to convert it into:

entry 1 entry 6 entry 11
entry 2 entry 7 entry 12
entry 3 entry 8 entry 13
entry 4 entry 9 entry 14
entry 5 entry10 entry 15

Is this possible without making a makro?

Thanks for your help

- Marco

Hi Carim!

Thanks for your attention, but I didn't express my problem clearly.
I need to break up a one column list list into several columns, so the result becomes a table, in this case with 3 columns:

entry1 entry6 entry11
entry2 entry7 entry12
entry3 entry8 entry13
entry4 entry9 entry14
entry5 entry10 entry15

Been working with this for some hours now, pretty fed up. Really hope somebody knows...

- Marco

Hi VBA noob

OK. My data layout is a column which I need to break up into a table with several columns. The original layout has empty cells where it is supposed to start a new column. So:

entry1
entry2
entry3
entry4

entry5
entry6
entry7
entry8

should become a table with two columns and 4 rows:

entry1

entry6

entry2

entry7

entry3

entry8

entry4

entry9

Can this be done without writing a macro?

- Marco

ooops correction, the output should be (2 columns, 4 rows):

entry1 entry5
entry2 entry6
entry3 entry7
entry4 entry8

AHHH YES!

That worked, thanks a lot

Sorry I didn't attach the xls file, the upload failed...

- Marco

I have a list generated by a proprietary software. It has taken the entire address list for people and put them one after the other in a single column.

How can I move these rows out to separate columns using a macro or other step that will keep me from going through 11,000 rows to correct this data?

Marion

PS I am told that this is the only way this software can generate this list, so I will be dealing with this over and over again.

you have to tell us how many rows there are for each record and does it vary. maybe even post a zipped version of the top few lines of the spreadsheet

Regards

Dav