Forum Discussion
Transform my data from multiple lines to one line per student
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.
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.
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
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.
- Thanks!!! Looks like I need to view a few basic videos to get me on first base. This is helpful!
Phyllis