How to transform a single column hierarchy into multiple columns in power query

Question

Hi&nbsp;How can I transform a single column hierarchy like this&nbsp;1Name 111Name 11111Name 111112Name 11212Name 12121Name 121122Name 1222Name 221Name 21211Name 211into something like this&nbsp;1Name 111Name 11112Name 1121Name 112Name 12121Name 1211Name 112Name 12122Name 1222Name 221Name 21211Name 2112Name 221Name 21212Name 2122Name 222Name 22221Name 2212Name 222Name 22222Name 222

v-chuncz-msft · Answer

Credo,
&nbsp;
You may try adding custom column.
let
    r = _
in
    Table.SelectRows(Source, each Text.StartsWith(r[Column1], [Column1]))

Forum Discussion

How to transform a single column hierarchy into multiple columns in power query

1 Reply

Related content

Table Transformation

Transform columns / type

Date hierarchy

Data transform using power query

Table Transformation

1	Name 1
11	Name 11
111	Name 111
112	Name 112
12	Name 12
121	Name 121
122	Name 122
2	Name 2
21	Name 21
211	Name 211