The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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!)