List to table

**marcov** · 03-05-2007, 05:30 AM

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** · 03-05-2007, 05:40 AM

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

VBA Noob

**marcov** · 03-05-2007, 05:51 AM

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** · 03-05-2007, 05:53 AM

Where did entry5 go and how did you get entry9

What are the cell references

Easier if you attach a file.

VBA Noob

**marcov** · 03-05-2007, 05:54 AM

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

entry1 entry5
entry2 entry6
entry3 entry7
entry4 entry8

**Carim** · 03-05-2007, 06:02 AM

may be ...

=OFFSET($A$1,MOD(ROW()-1,5)+(COLUMN()-1)*5,0)

P.S. replace 5 by 4 for your last example ...

**marcov** · 03-05-2007, 06:36 AM

AHHH YES!

That worked, thanks a lot

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

- Marco

**Carim** · 03-05-2007, 06:38 AM

Glad your problem is fixed ...

Thanks for the feedback

List to table

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions