Help convert a table/range into another

Hi Pete thank you for the help

Well I did include the "after" on the sheet :-)

it is the rightmost section... the one where the days of the month are on a single row instead of several "weekly" rows

I wrote "turn this" into "THIS"

Thank you

Using Power Query to unpivot your data and get it normalized and then using Power Pivot to present your expected results.
1. Select each range of data your receive and convert to a Table. Highlight the range and select Ctl+T
2. Bring each into Power Query and Append each to the other. Clean up and unpivot.
3. Close and Load each to Power Pivot.
4. Create your pivot table and build a measure to concatenate the events for same day.

All above is shown in the attached file.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

Measure:

Please Login or Register  to view this content.

To build the measure, look at this tutorial.
https://www.sfmagazine.com/articles/...a-pivot-table/

Here is the Mcode to unpivot your three tables.

Please Login or Register  to view this content.