Arrange vertical string into multiple horizontal columns

**tribalgifts** · 10-16-2009, 01:38 PM

I have a string of values (header) and sub values which I wish to arrange into columns. The header values are static and always in the same order. The sub values can vary (e.g. sometime 2 entries sometimes 10 entries etc). How would I arrange these values into columns using the same formula?

**WHER** · 10-16-2009, 08:20 PM

One possibility:

**DonkeyOte** · 10-17-2009, 02:20 AM

I confess I'd be inclined to adopt a slightly different approach to avoid volatiles and errors (and volatile Conditional Formatting)

Using WHER's file and output table I'd probably opt for:

F2: =MATCH(F$3,$A:$A,0)
copied across to I2

F3: =IF(ROWS(F$3:F3)>(G$1-F$1-1),"",INDEX($A:$A,F$1+ROWS(F$3:F3)))
applied across matrix F3:H13

Arrange vertical string into multiple horizontal columns

LinkBack

Thread Tools

Rate This Thread

Display

Arrange vertical string into multiple horizontal columns

Re: Help Formula to arrange vertical string into multiple horizontal columns

Re: Arrange vertical string into multiple horizontal columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions