Pivot Table - Multiple Column Headers Merging After Filtering

Jhuck

New Member
Joined
May 15, 2019
Messages
5
Hi everyone,

I am having issues with a pivot table merging 2 column headers and count of values together when I filter out Blanks.


I've created an example workbook of the source data, what I'm doing (which is definitely wrong), and an example of what I want it to look like. https://www.dropbox.com/sh/1wky1or8aj1j7l7/AACD_KIYI5-NUPK_Ngz40tZ6a?dl=0

On top of this I need it to be able to refresh the pivot table without reformatting as part of a macro (I can write in the refresh)

I appreciate any help or advice you have! Thanks!
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,035
is that what you want
(with PowerQuery aka Get&Transform)

sourcePivot with PQ
AreaStoreRBTMTCount of Value
Area 1Store AAction RequiredRBRBRBTMTTMT
Area 1Store BAction RequiredAction RequiredAction RequiredReminderFirst DayAction RequiredReminder
Area 1Store BAction RequiredArea 1Store A
1​
Area 1Store CAction RequiredArea 1Store B
1​
2​
Area 1Store CReminderArea 1Store C
1​
3​
2​
Area 1Store CReminderArea 2Store D
1​
1​
2​
Area 1Store CAction RequiredArea 3Store E
3​
Area 1Store CAction RequiredArea 3Store F
1​
1​
1​
Area 1Store CAction RequiredArea 3Store G
1​
1​
Area 2Store DAction RequiredAction Required
Area 2Store DReminder
Area 2Store DAction Required
Area 3Store EAction Required
Area 3Store EAction Required
Area 3Store EAction Required
Area 3Store FAction Required
Area 3Store FReminder
Area 3Store FFirst Day
Area 3Store GAction RequiredAction Required
 

Jhuck

New Member
Joined
May 15, 2019
Messages
5
Hi, do you have the steps for how you achieved the pivot? I just can't make it work
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,035
You are welcome

Now you can hit Like/Thanks button in the posts which helped you ;)

Have a nice day
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,095,615
Messages
5,445,491
Members
405,334
Latest member
Marcfar

This Week's Hot Topics

Top