power query editor

Highlighted
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
Highlighted

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

Highlighted

Thank you so much :)