Moving Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1579180%22%20slang%3D%22en-US%22%3EMoving%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579180%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20can%20see%20below.%26nbsp%3B%20I%20have%20been%20trying%20to%20figure%20out%20the%20easiest%20way%20to%20do%20this.%26nbsp%3B%20I%20was%20on%20Power%20Query%20today%20maybe%20seeing%20if%20there%20was%20an%20easy%20way%20to%20do%20it%20on%20there%20as%20well.%26nbsp%3B%20I%20get%20a%20huge%20list%20of%20people's%20schedules%20exported%20to%20Excel%20that%20looks%20like%20the%20example%20below.%26nbsp%3B%20What%20I%20usually%20do%20is%20cut%20and%20paste%20the%20person's%20name%20into%20the%20column%20to%20match%20the%20schedule.%26nbsp%3B%20I%20have%20even%20done%20a%20macro%20to%20do%20this%20but%20still%20seems%20like%20a%20lot%20of%20work%20to%20do.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Information.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208562i716B7179FA2304DD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Excel%20Information.PNG%22%20alt%3D%22Excel%20Information.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1579180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1579630%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388576%22%20target%3D%22_blank%22%3E%40scottmaxwell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20clarify%20from%20which%20paste%20to%20which%20one%20you%20copy%20and%20paste%20names%3F%20If%20fill%20down%20by%20names%20first%20column%20-%20yes%2C%20such%20option%20is%20built-in%20in%20Power%20Query.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

Excel Information.PNG

1 Reply
Highlighted

@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.