Forum Discussion
Unpivoting clustered columns
Like, currently I have it like this: Id V1 V2 V3 A1 A2 A3 B1 B2 B3 1 v1.1 v2.1 v3.1 a1.1 a2.1 a3.1 b1 .1 b2 .1 b3.1 2 v1.2 v2.2 v3.2 a1.2 a2.2 a3.2 b1 .2 b2 .2 ...
=Table.FromPartitions("Id",Table.ToList(YourTable,each {_{0},Table.FromColumns(List.Split(List.Skip(_),3),{"V","A","B"})}))
I presume this one has the same trouble as the other, that sometimes my field names are not just but V1 V2, but sometimes are V1: V2, this the trailing characters are not always numbers.