Shirley Moreman
New member
- Joined
- May 8, 2022
- Messages
- 4
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 365
Hi,
I'm fairly new to Power Query so have got stumped by this one. I have a set of data for event schedules that I need to transform form blocks of columns relating to dates into a table with rows for the data in each date, including the date and other record information.
So I want to go from this:
to this:
I've got as far as using Transpose and Fill down to set up the dates and create a list of these, but I'm stuck then with how to pick up the other data and get it into the format I need. I've done some searching but haven't found anything like this.
Any help would be much appreciated.
I'm fairly new to Power Query so have got stumped by this one. I have a set of data for event schedules that I need to transform form blocks of columns relating to dates into a table with rows for the data in each date, including the date and other record information.
So I want to go from this:
to this:
I've got as far as using Transpose and Fill down to set up the dates and create a list of these, but I'm stuck then with how to pick up the other data and get it into the format I need. I've done some searching but haven't found anything like this.
Any help would be much appreciated.