Add more than one column of text to a pivot table in Excel - SMARTpro Academy
👩💻 Those of us who already work with pivot tables know how to place one field below another in the same column, but... what if I want the fields in different columns?
How do I do it? Let me explain... after you have the fields arranged one below the other in the ROWS area of your pivot table, go to the "Design" tab, then click the "Report Design" button, and then select "Display in Tabular Format"... and that's it! 😁
Did you like it? Support me with a LIKE 👍 or tag someone who might find this tip useful.
You can also stay connected with me on Instagram and Facebook 😁: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
-----------------------------------------------------------------------
Would you like to know your current Excel level? Take our free test:
https://maraton.smartprosoluciones.co...
Do you want to take your Excel skills to the next level 👩🏻💻 👨🏻💻 and stand out from the crowd of professionals? Great news! You have the option to take our courses LIVE ONLINE 😁 or in person in Panama. Visit our website for more information.
https://www.smartprosoluciones.com/cu...
-----------------------------------------------------------------------
💡💻 Get the Microsoft Excel 365 version:
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...