Forum Discussion
jesperhjermitslev
Jan 02, 2019Copper Contributor
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?
- jesperhjermitslevCopper Contributor
Thank you so much :)
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