Moving Columns

[scottmaxwell]

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?

[#2]

@scottmaxwell 

Could you please clarify from which paste to which one you copy and paste names? If fill down by names first column - yes, such option is built-in in Power Query.

[#3]

@Sergei Baklan Thanks for answering.  What I am trying to do is move the name to the time above.  Which would mean moving the name down one column.

[#4]

@scottmaxwell 

In Power Query you may add two Index columns, one starts from 0 and another starts from 1, merge the table with itself on these two columns and expand info from the next row.