Forum Discussion
Solved
Turning alternate rows into columns - Power Query/M Function
So I have some messy data coming from pdf invoices which I have 95% cleaned how I want, but I cannot work out the last step. I am copying the data into a table with ctrl a/c/v and it spits it int...
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.
Thanks again.
And it works. Set up now.
davidmaddock54 Glad you could work it out!