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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 6 | |
| 5 | |
| 4 | |
| 3 |