I've never used a pivot table although they appear to be something I should explore.

Came up with this macro solution.
Incorporates a separate macro to produce a list of unique products that's used as
filters, then copies the results.

Hit Alt + F8 to bring up the macro dialogue and run the DataArrangement macro.

As per normal with Excel, there's always more than one way of doing anything.

Good Luck with your project.

Attached Files

Haha88_Test.xlsm (21.0 KB, 14 views)