'Row Grouping' macro for damsel in distress

flex33

New Member
Joined
Feb 23, 2012
Messages
37
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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,211,434
Messages
6,101,830
Members
447,758
Latest member
jojo3strada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top