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

Frequent Visitor

          Computer          Math      Stats

Alex         x

Alex                                 x

Alex                                                 x

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

2 Replies

@CCSJonell 

Maybe with Power Query.

classes.JPG

You can do a pivot table. 

@CCSJonell