Forum Discussion
Take 2 on concatenating a group of related cells across several rows into one cell
OliverScheurich was great to help me on the original request. The request has greatly simplified and I have started to get results but sadly stuck on trying to de-compose the original solution prov...
Thanks again Oliver for your work and quick response. I don't believe I was clear enough in the previous example spreadsheet. I need to take the component SKU and quantity from each of the component rows associated to the BUNDLEID and concatenate them in the yellow colored cell in the BUNDLEID row. No need anymore to generate a separate table.
=LET(rng,A3:D15,
BYROW(SEQUENCE(ROWS(rng)),LAMBDA(b,IF((INDEX(rng,b,3)="")*(INDEX(rng,b,2)<>""),TEXTJOIN({"-".","},,FILTER(CHOOSECOLS(rng,3,4),CHOOSECOLS(rng,1)&CHOOSECOLS(rng,2)=INDEX(rng,b,1)&INDEX(rng,b,2))),""))))
You are welcome. This formula should return the intended output. Unfortunately i didn't understand the requirement when i posted my last reply.
- Hey Oliver. Got it working in my spreadsheet. Learned quite a bit from your formula. Thanks for everything.