I'm a novice at this, so asking for your help.
The setup: I have a standard pivot table output which I've copied and paste-as-values onto a new sheet. The intended audience doesn't know how the expending/collapsing pivot feature works - I can't train 200 people - but they do understand 'grouped' rows. SO…I need an executable macro that can group the data to mimic the layering of rows like a pivot table.
before
http://imageupper.com/i/?S0200010070...40326785945490
after
http://imageupper.com/i/?S0200010070021A1340326785945490
I have no idea how to attach the xlsb file here, so I uploaded it here: http://www3.zippyshare.com/v/10236269/file.html
Extra details: The sample sheet shows 4 Accessory categories, my actual data has 50 categories, 100 sub categories on 3000 rows. Each category is separated by a single row.
For flexibility, additional blank rows can be inserted between the subgroups, if it helps the macro. A false index can even be created in any blank columns as well. I also have no idea why those text indentations exists when I copied over, but they are a nice visual help.
The setup: I have a standard pivot table output which I've copied and paste-as-values onto a new sheet. The intended audience doesn't know how the expending/collapsing pivot feature works - I can't train 200 people - but they do understand 'grouped' rows. SO…I need an executable macro that can group the data to mimic the layering of rows like a pivot table.
before
http://imageupper.com/i/?S0200010070...40326785945490
after
http://imageupper.com/i/?S0200010070021A1340326785945490
I have no idea how to attach the xlsb file here, so I uploaded it here: http://www3.zippyshare.com/v/10236269/file.html
Extra details: The sample sheet shows 4 Accessory categories, my actual data has 50 categories, 100 sub categories on 3000 rows. Each category is separated by a single row.
For flexibility, additional blank rows can be inserted between the subgroups, if it helps the macro. A false index can even be created in any blank columns as well. I also have no idea why those text indentations exists when I copied over, but they are a nice visual help.