Imke Feldmann shows us how to pivot a single column into a fixed number of columns using Power Query:
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.
Note that this is different from the Entity-Attribute-Value model, as there’s no entity or attribute—it’s just values.