How to Flatten and repeat Row Labels in a Pivot Table

This video shows you how to easily flatten out a Pivot Table and make the row labels repeat. This is useful if you need to export your data and share it with someone else - possibly for upload into another database etc.

[Hello-yqls]

PERFECT!!! My wife is now calmer than a newborn baby sleeping in a bed after i did this. Thanks Sir. Godbless.

[tastyjay]

This video is a GOD SEND. I've wasted so much time by not looking for this solution before. Thank you for sharing this quick, clear solution!!!

[ExcelAtData]

Great video Matt. Another way to do this is to Right Click in your Pivot Table > Pivot Table Options > Display tab > Tick "Classic Pivot Table Layout" box.

[LaurenTaylorCakeDecorator]

You literally just saved me hours of work and gave me to ability to fix my raw data so I can present granular level detail to my boss who only believed we could have an overview of things due to the shape of our raw data. Brilliant!!!

[massimocarrara]

Thanks, I lived in ignorance for decades, that's great!

[techknowledge]

Thank you very much. This is exactly what I needed. You're explanation is straight to the point. Getting rid of the "Subtotals" was a plus!

[arturobrunocm]

thank you so much, been a week tryng to figure out this!

[nasruminallahmian]

brilliant, a concise & focused video. Thumbs up..

[jameslawlor]

Thank you, this helped a lot with a report I had to put together for work.

[pratik]

You saved me today at work. Thank You !!

[nikhilitagi]

Thank you so much, this where I had stuck, thankyou once more for making this session.

[sanjay.]

Thanks, Excelerator. It worked for me.

[zouz]

Thank you so much for sharing that. Saved a lot of time!

[mogvgb]

Legend, helped break an irritated deadlock with my boss on how to present some data :D

[StephenPodcast]

Thanks a lot. Absolutely what I needed.

[writingsofananonymouswrite]

Thank you Super!!! helpful this was.. lots of luv n light

[jbass]

Quick, informative and best of all it worked perfectly!

[davidthompson]

Perfect!  This is just what I needed!  Thank you!

[vincentpitts]

OMG! This is so awesome! This is exactly what I was looking for.

[cardozowagner]

This exactly what I am looking for, thanks!