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 ...
Merge the columns into V A and B. Then split the collumns checking the box to split into rows.