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.
|