Forum Discussion
Solved
Pivot the table
Hi guys, I really need your help I want to change the table (table one) from this one Column1 1 A B 2 C 3 D E 4 F G 5 H to this one (table...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], group = Table.Group( Source, "Column1", {"x", (x) => x[Column1]}, GroupKind.Local, (s, c) => Number.From(c is number) ), z = Table.FromList(group[x], (x) => x, {"No", "Manchester", "Arsenal"}) in z
You can extract the text into a new column using if each List.Contains({0..9}, [Column1])then [Column1] else null) and then fill down that column. Then remove any rows where Column1 = number column. Then group by filldown column, and extract to new columns. I can't write out the code right now, but logically, thats how I would do it.
--Nate