formula - Displaying Excel cell values in a comma-separated list -

formula - Displaying Excel cell values in a comma-separated list -

i have info in excel this:

column1 column2 ni-summer-2 parent ni-548 underneath kid ni-549 ni-550 ni-summer-1 parent ni-421 underneath kid ni-422

i need add together new column displays children in 1 string joined commas, so:

column1 column2 column3 ni-summer-2 parent ni-summer-2,ni-548,ni-549,ni-550 ni-548 underneath kid ni-549 ni-550 ni-summer-1 parent ni-421,ni-422 ni-421 underneath kid ni-422

(the values below each parent should comma-separated in next column.)

please help resolve this.

assuming blank row between entries.

create 2 columns d , e

in column e, set in e1 , re-create formula down:

=if(or(isblank(a2),isblank(a1)),a1,a1&","&e2)

in column d, set in d1 , re-create formula down:

=if(mid(a1,3,8)="-summer-",e1,"")

excel formula