Multiple rows of data for one person that need to be put into separate columns

Question

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Computer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Math&nbsp; &nbsp; &nbsp; StatsAlex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xAlex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xAlex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xI need for all three of Alex's classes to be on one line (without clicking and dragging) I have&nbsp;@900 kids to do this with and I will never get done if I have to drag and drop

oliverscheurich · Answer

CCSJonell&nbsp;Maybe with Power Query.

alannavarro · Answer

You can do a pivot table.&nbsp;CCSJonell&nbsp;

Forum Discussion

Multiple rows of data for one person that need to be put into separate columns

2 Replies

Resources