power query editor

[jesperhjermitslev]

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]

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

[#3]

Thank you so much :)