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 :) 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies