Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! 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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
22 | |
14 | |
11 | |
7 | |
7 |