As you can see below. I have been trying to figure out the easiest way to do this. I was on Power Query today maybe seeing if there was an easy way to do it on there as well. I get a huge list of people's schedules exported to Excel that looks like the example below. What I usually do is cut and paste the person's name into the column to match the schedule. I have even done a macro to do this but still seems like a lot of work to do. Any ideas?