List To Matrix - Pivot Tables FAIL but Functions Can DO It

[@reng7777]

SIMPLY GENIUS AMIGO!!! I HOPE WHEN I AM 100 YEARS OLD I REACH YOUR EXCEL LEVEL!!!

[@Officeinstructor]

You can do it!

[@houstonsam6163]

Excellent, clear content as always.

[@Officeinstructor]

Much appreciated!

[@nadermounir8228]

U bring tbe best quality formulas in Excel. Another amazing tutorial Nabil. Thanks again for sharing your knowledge with us 😊

[@Officeinstructor]

Thank you so much 😀

[@Al-Ahdal]

Great work, one thing do you use "conditional formatting" for the blank rows separating the two datasets?

[@Officeinstructor]

Yes I do!

[@IvanCortinas_ES]

Great Nabil. This method of approaching it is very interesting. I loved those transpositions. Thank you my friend!!

[@Officeinstructor]

Glad you liked it! and thanks for watching

[@svenh5752]

It was, as usual, an interesting solution.
I figured out that the two pivot tables can be merged by summation: =H2:S13+H17:S28

[@Al-Ahdal]

First Comment.

[@Officeinstructor]

Good for you

[@Al-Ahdal]

Sir, could we get an Excel work File to download? Thank you

[@Officeinstructor]

Sorry, no file to share for this tutorial

[@nadermounir8228]

U bring tbe best quality formulas in Excel. Another amazing tutorial Nabil. Thanks again for sharing your knowledge with us 😊

[@Officeinstructor]

Thank you so much 😀