Concatination of data organised vertical data and differing amounts

[batchjb69]

Hi,

I wish to concatenate data from column B into one cell from data in rows of varying numbers based on the number in column B.

For example 101 has apple, orange and banana in cells B2,B3 & B4. But I want this in one cell next to 101.

This is an example of a spreadsheet that has 100s of numbers in column a with a differing number of data rows. in the example 101 has 3 rows of data but 102 only 2


Input

Number Fruit
101 Apple
101 Orange
101 Bannana
102 Bannana
102 Kiwi
103 Bannana
103 Strawberry
103 Melon
103 Cherry
103 Kiwi
104 Bannana
104 Kiwi

Output

Number Fruit
101 Apple,Orange,Bannana
102 Bannana,Kiwi
103 Bannana,Strawberry,Melon,Cherry,Kiwi
104 Bannana,Kiwi

[nankw83]

Hi batchjb69,

Try the below code …

Please Login or Register  to view this content.