power query editor

New Contributor

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?


2 Replies

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


Thank you so much :)