I have a given excel schedule, similar to the “Input” table shown in the attachment.   I have a need to organize this table by event and show participants in individual columns.  I have this table shown as “Desired Output” in the attachment  I also have Power BI available to me, if that provides an easier solution. 

Any and all help would be greatly appreciated, thank you.

Sheet 

​ I have a given excel schedule, similar to the “Input” table shown in the attachment.   I have a need to organize this table by event and show participants in individual columns.  I have this table shown as “Desired Output” in the attachment  I also have Power BI available to me, if that provides an easier solution.  Any and all help would be greatly appreciated, thank you. Sheet   Read More

​