Pivot Table with blanket rows

abc3132 · #1 11-08-2017, 04:23 PM

Hi Xor.
Thanks for your commitment.
Please have a look at the attached file

The first tab "System Layout" shows how the system report

The second tab"NO" is the pivot table generated from the first tab "System Layout". Please observe that everything is messed

The third tab "Layout to Pivot" is how Excel need the information to generate an accurate and correct Pivot table

The fourth tab "YES" is how I would like to have the report. Please observe that here the "products" belong to the right "AC" & "Customer"

So the idea is to have the fourth pivot table from the first one. If is necessary with or without intermediate steps.

Thanks, Adrian

xor · #2 11-09-2017, 12:39 AM

See the last sheet.

All the steps described in this last sheet can you of course perform on your data in sheet System Layout.
Be sure to select only the relevant data when you run the macro.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table - Copy Rows	theexpat	Excel Programming	0	02-26-2016 08:14 AM
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Average over all pivot rows in excel	Andrey	Excel	2	07-23-2014 07:51 AM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Excel Pivot - Do not display rows with zero value	patidallas22	Excel	1	03-08-2013 01:35 PM