Forum Discussion
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 co...
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