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.
One more variant for the collection
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Items = Table.AlternateRows(Source,1,1,1),
Values = Table.AlternateRows(Source,0,1,1),
Result = Table.FromColumns( {Items[Column1], Values[Column1]}, {"Value", "Item"} )
in
Result- Thank you. More options and chances to work with M functions the better. There's a few more things I may need from this info, might be handy to have alternative options.
