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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

how to turn column into list of lists?

I have a table with just one column that looks like this: 

 

Header
"Apple","Banana"
"Orange", "Pineapple"
"Lime", "Watermelon"
"Dragon Fruit", "Cherry"

 

I would like to turn this column into a list of lists, such that each record becomes a unique list, like this: 

 

{

{"Apple","Banana"},

{"Orange", "Pineapple"},

{"Lime", "Watermelon"},

{"Dragon Fruit", "Cherry"}

}

 

Any ideas how to do this?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

oh wait, I think answer might be the function Table.ToRows (what an ininutitive name for this function!)

View solution in original post

1 REPLY 1
Anonymous
Not applicable

oh wait, I think answer might be the function Table.ToRows (what an ininutitive name for this function!)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors