Efficiency 365 Live Stream Schedule

Join me on YouTube live. One topic. In-depth coverage in 15 minutes.

Upcoming Streams

Youtube logo

Watch Past Live Streams

Youtube logo

6 Responses

  1. 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.

  2. 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).

    1. 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.

Queries | Comments | Suggestions | Wish list