Jun 06 2021 03:08 AM
Jun 06 2021 03:42 AM
@Drpstone Power Query can transform this into the format you need. But first you need to convert your data to an Excel table. Check out Mike Girvin 'Excel is Fun' on You Tube for tutorials on how to do this.
Jun 06 2021 03:51 AM
Jun 06 2021 03:59 AM
Jun 06 2021 04:59 AM
@Drpstone Perhaps the attached file holds a solution that works for your. One with Power Pivot and one with Power Query. I didn't pay much attention to making the column headers nice, but that's something easily adjusted. Neither of them is very complicated.
Jun 06 2021 05:53 AM
@Drpstone This an introduction to PQ and Power Pivot https://youtu.be/ohGFPF12Qwc
Jun 06 2021 05:55 AM
Yes...that's it. How did you do it? I'm a newbie and figuring out most things by trial and error. Can you send the steps? Or a link to a youtube video with the steps explained.
Thanks,
Phyllis
Jun 06 2021 06:03 AM
Jun 06 2021 06:31 AM
Solution@Drpstone The Power Query (PQ) solution requires only two steps. Connect to the (structured) table.Unpivot without aggregation. Perhaps a good idea to learn more about the basics from the attached link.
https://exceloffthegrid.com/power-query-introduction/
I can't really explain it better myself. Then you can follow the "applied steps" in the file that I sent earlier.
Jun 06 2021 06:49 AM
Jun 06 2021 06:31 AM
Solution@Drpstone The Power Query (PQ) solution requires only two steps. Connect to the (structured) table.Unpivot without aggregation. Perhaps a good idea to learn more about the basics from the attached link.
https://exceloffthegrid.com/power-query-introduction/
I can't really explain it better myself. Then you can follow the "applied steps" in the file that I sent earlier.