Forum Discussion
Turning alternate rows into columns - Power Query/M Function
davidmaddock54 The attached workbook contains a working query that does what you asked for. I trust you can get it to work in your own schedule.
It involves adding an Index column from zero. Then a Modulo of 2 on the Index, creating a column with alternating zeroes and ones. Pivot the Modulo column without aggregation of Column1 and do some cleaning up.
davidmaddock54 The attached workbook contains a working query that does what you asked for. I trust you can get it to work in your own schedule.
It involves adding an Index column from zero. Then a Modulo of 2 on the Index, creating a column with alternating zeroes and ones. Pivot the Modulo column without aggregation of Column1 and do some cleaning up.
- Oh, scrap that, errors on work computer, but it shows on my own laptop. Handy. I can do some comparisons and make sure I go step by step.
Thanks again.- And it works. Set up now.
davidmaddock54 Glad you could work it out!
- Thanks so much. I get an error when I open the query editor, but I think I can follow the steps in the formula bar. It certainly spits out what I want at the end.
