How to combine multiple columns into one reportable chart??

[kat_desade2]

Hi All,</SPAN>

I have searched high and low, so apologies if this has been asked before.</SPAN>

I am not sure if I am pushing Excel further then what it is cable of</SPAN>
I have a work book with a table that goes from A12 to Z468 that is used for reporting purposes. </SPAN>

• My header row is A12 to Z12</SPAN>
• In A12 B12 C12 are locations and sub locations – ie: A12 is Country B12 is State C12 is City</SPAN>
• In F12 is the quarter the audit has happened in</SPAN>
• In O12 is a primary issue</SPAN>
• In S12 is a secondary issue</SPAN>
• In W12 is a tertiary issue</SPAN>

Is there a report / pivot table that could be built to group O12, S12, W12 based on the information in F12, and / or A12, B12, C12</SPAN>
Ie: a summary of over all issues reported based on the yearly quarter and the region that reported them.
</SPAN>
I can show a breakdown of this information by keeping each issue column separate, but I was hoping there was a way to combine those three columns into an overall figure</SPAN>

Many thanks in advance! </SPAN>

Regards, Kat</SPAN>

 

[Asala42]

While there may be an approach that I'm overlooking, your specific data layout is not very friendly towards building a pivot table of top issues.

If this was my project I'd likely resort to a few copy/pastes to make an "Issues" table that puts the Primary/Secondary/Tertiary issues into one column, with perhaps an additional column that signifies the primary/secondary/tertiary flag if you need it. So rather than your current table with presumably 1 record per audit, this would be an equivalent table with 1 record per issue. Basically the same data but with a different layout, more rows with a couple less columns, but the resulting table would be something you could pivot very easily