Join me on YouTube live. One topic. In-depth coverage in 15 minutes.
Upcoming Streams
Watch Past Live Streams
Menu
Menu
Join me on YouTube live. One topic. In-depth coverage in 15 minutes.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
6 Responses
Request to update video on Excel table covering multi row headers with merged cells.
What do you want me to update? Is it not working?
No. It is about giving explanation on how to convert multi row and merged cells kind of data clean up operation steps with few examples.
Here is the video https://youtu.be/rX83Bp7mndE
Another link – https://youtu.be/QbRgeskSn0U
No Sir, your suggestions are perfectly fine and are working. It is about including some detailed video on how to use “table” utility with raw data having multi-layers rows (multiple headers in 2 or more merged columns).
Thanks.
You cannot create Excel Table where the data has multiple rows of headers.
Tables are for raw data – which is the INPUT data.
There is no reason for input data to have multi-row headers.
If it has – then it needs to be simplified (cleaned).
Output data – reports – can have any number of headers levels and merged cells.
You can generate reports using Pivots or Manually.