Forum Discussion

jesperhjermitslev's avatar
jesperhjermitslev
Copper Contributor
Jan 02, 2019

power query editor

Dear all

 

I have imported a text dokument to my excel.

And have worked with it.

 

Now i have a problem.

I have only one column. and every second line in that column i would like to bring to column 2.

like this:

- column one line 1-3-5-7-9-11 etc

- column two line 2-4-6-8-10-12 etc

 

Is that possible?

 

  • If move every second row in new column

    - duplicate your query

    - for the first query Remove alternate rows (with 1,1,1), add Index column

    - for the second query Remove alternate rows (with 2,1,1), add Index column

    - Merge second query with the first one on Index as Full outer

    - remove Index column

Resources