Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Solved! Go to Solution.
oh wait, I think answer might be the function Table.ToRows (what an ininutitive name for this function!)
oh wait, I think answer might be the function Table.ToRows (what an ininutitive name for this function!)