List to table

[marcov]

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

[Carim]

Hi,

=concatenate(a1,a6,a11)

[marcov]

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

[VBA Noob]

Can you post an example of your data layout and expected results

VBA Noob

[marcov]

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

[VBA Noob]

Where did entry5 go and how did you get entry9

What are the cell references

Easier if you attach a file.


VBA Noob

[marcov]

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

entry1 entry5
entry2 entry6
entry3 entry7
entry4 entry8