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


Maybe with Power Query.


You can do a pivot table.