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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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