Group or Add text

**mrcois** · 06-10-2010, 07:12 AM

On the attached sheet I want to Group or Add text directly underneath each other from multiple cells.

**DonkeyOte** · 06-10-2010, 08:26 AM

Obvious questions based on the sample would be:

a) are the values in Col A always numeric ?

b) are the values in Col A always unique ?

c) does the order of the final table matter - ie if 3704 were listed first would this be an issue ?

**mrcois** · 06-10-2010, 08:32 AM

a) No they might also be something like: W08016 or FC46A

b) Yes they will always be unique with numbers or numeric.

c) No the order would not matter, as long as they list directly below each other

**DonkeyOte** · 06-10-2010, 08:39 AM

Shame about non-numerics but a simple method, to avoid need for expensive formulae would be:

C1: 1
C2: =MAX(C$1:C1)+(A1<>"")
copied down for all rows

Then:

G1: =INDEX(A:A,MATCH(ROWS(G$1:G1),$C:$C))
applied across matrix G1:H5