How to display matched values ​​in google spreadsheet?

Question

Google Sheets

There is column 1, in which the name of the product, and there is column 2, in which the categories of the product. It turns out that the product can be in several categories. How to display a pivot table, which will indicate the product and all categories for it?

Answer 1

The easiest way is to use the formula to combine everything.

=ARRAYFORMULA({UNIQUE(A3:A), TRIM(
  REGEXREPLACE(
    TRANSPOSE(QUERY(IF(A3:A=TRANSPOSE(UNIQUE(A3:A)),B3:B&", ",""),,TRANSPOSE(ROWS(A3:A)))),
    "(^\s+|\s*,\s*$)",
    ""
  )
)})

Unfortunately, without an example, you can not download something specific.