Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not 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 look something like

Valuetexttimebit
8abc2021.01.01 13:45:00011010

 

 

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Fount the solution

 

When converting "to table" you have to choose as a delimiter "none".

 

reneton_0-1611772088972.png

 

After that it is possible to transpose the table.

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Fount the solution

 

When converting "to table" you have to choose as a delimiter "none".

 

reneton_0-1611772088972.png

 

After that it is possible to transpose the table.

 

manikumar34
Solution Sage
Solution Sage

@Anonymous , 

 

Try unpivoting using power query.

 

https://www.myexcelonline.com/blog/unpivot-data-using-excel-power-query/

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Anonymous
Not applicable

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

amitchandak
Super User
Super 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/

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

The problem is, it is not a table, therfore transpose or unpivot are not available. it's a list.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.