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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.