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%3CLINGO-SUB%20id%3D%22lingo-sub-1763994%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1763994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20for%20answering.%26nbsp%3B%20What%20I%20am%20trying%20to%20do%20is%20move%20the%20name%20to%20the%20time%20above.%26nbsp%3B%20Which%20would%20mean%20moving%20the%20name%20down%20one%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1767713%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767713%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%3EIn%20Power%20Query%20you%20may%20add%20two%20Index%20columns%2C%20one%20starts%20from%200%20and%20another%20starts%20from%201%2C%20merge%20the%20table%20with%20itself%20on%20these%20two%20columns%20and%20expand%20info%20from%20the%20next%20row.%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

3 Replies
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.

Highlighted

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

Highlighted

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