The demand to unstacking a column into a table is not rare (see here for example: PowerBIForum ) . Also if you copy a table from a post in the Power BI community forum to the enter-data-section in Power BI, it will show up as such a one-column-table.
Table.FromRows( List.Split( Table1[Column1], 3) )
..provided that your table is named “Table1”
How it works
You have to read a formula like this like an Excel formula: From inside out.
Transform a table to a list-format by selecting the relevant column (here: [Column1])
2. Chunk up the list into a nested list with one list per each row
The number in the last argument of the function determines the number of columns of the desired table.
3. Create table from that list
This formula creates a table from a list of rows. Those rows have to be in the format of a list as well, so the desired input matches exactly the format from step 2.
4. Optionally: Integrate column names for the new table
I prefer this formula-solution to other methods that use the UI and add index- and modulo columns before finally pivoting. Mainly, because I don’t have to create a function to apply this transformation within an add-column-step where I want to apply it to all rows of a table.
Enjoy & stay queryious 😉