Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Since this is a list, options like unpivot are not available. I think I have to use dax.