Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 look something like
Value | text | time | bit |
8 | abc | 2021.01.01 13:45:00 | 011010 |
Since the source is a list, transforming options like pivot, unpivot are not available.
Trying to convert the list in a table "to table" results in errors, since each row is another type.
best
aleks
Solved! Go to Solution.
Fount the solution
When converting "to table" you have to choose as a delimiter "none".
After that it is possible to transpose the table.
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 ,
Try unpivoting using power query.
https://www.myexcelonline.com/blog/unpivot-data-using-excel-power-query/
Regards,
Manikumar
Proud to be a Super User!
Since this is a list, options like unpivot are not available. I think I have to use dax.
@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/
The problem is, it is not a table, therfore transpose or unpivot are not available. it's a list.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |