...

Group rows and concatenate cell values

 

Here is a categorized detail table:

A

B

1

Name

Name 2

2

Unique 1

ex 1

3

Unique 1

ex 2

4

Unique 1

ex 3

5

Unique 2

ext 1

6

Unique 2

ext 2

7

Unique 2

ext 3

8

Unique 2

ext 4

9

Unique 2

ext 5

We need to group the table and concatenate the detail data using the semicolon.

D

E

1

Unique 1

ex 1;ex 2;ex 3

2

Unique 2

ext 1;ext 2;ext 3;ext 4;ext 5

Use SPL XLL to do this:

=spl("=E@b(?.groups(~1;concat(~2;$[;])))",A2:B9)

Picture4png

E@b function converts the two-dimensional table to a sequence. ~1 represents the first sub-member of the current member; and $[] represents a string.

Source:https://www.reddit.com/r/excel/comments/1ctacn1/combine_data_from_multiple_rows_into_one_based_on/


 
 •  136 View  •