Forum Discussion
Solved
Transform my data from multiple lines to one line per student
I need to transform my data multiple grades per student to one line per student with multiple columns for grades. For example: 100123456. John Smith PHM 123 A 100123456 John Smith PHM 124 B 10...
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.
My data is already in an excel table. Is there a specific video you can direct me to? I’ve been searching and I haven’t found the particular video.
Drpstone This an introduction to PQ and Power Pivot https://youtu.be/ohGFPF12Qwc