Forum Discussion
Anonymous
5 years agoNot applicable
Convert list with different types to table
Hi all I have a list like List 8 abc 2021.01.01 13:45:00 011010 How can I convert this list to a table? Is there a function or do I need to do it manually? Should lo...
- Anonymous5 years ago
Fount the solution
When converting "to table" you have to choose as a delimiter "none".
After that it is possible to transpose the table.
amitchandak
5 years agoSuper User
Anonymous , with the first table it seems like a case for transpose table or unpivot
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
- Anonymous5 years agoNot applicable
The problem is, it is not a table, therfore transpose or unpivot are not available. it's a list.