Request to update video on Excel table covering multi row headers with merged cells. Loading... Reply
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).
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.