Hi, I work with products and consistently have a list of products that are included in a "set". I need to be able to join all items in a set (product numbers and quantities - from different rows) into one cell, but start over for each new set listed (after a blank row). Sample spreadsheet is attached, with values needed in column G. I have also attached an image for preview.
I was hoping there would be a formula and not a macro, as I may need to re-create the formula for Google Sheets.
I appreciate any help you can provide!
Bookmarks