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.
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.
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