Forum Discussion
Table with two list
Good afternoon! I have a table with two columns in list format, one for contacts and the other for files. I want to expand both columns to see the data. How can I do this? If I use the built-in P...
kevinEGE , create a new column
using two list columns
Zip=
let
_break = List.Zip( {[COlumn1], [COlumn2]} ),
_Trans = List.Transform(_break, each Record.FromList(_, {"Subject", "Marks"}))
in
_Trans
and then expand record
Table.ExpandListColumn(#"Added Custom", "Zip")
next step
Table.ExpandRecordColumn(#"Expanded Zip", "Zip", {"Subject", "Marks"}, {"Zip.Subject", "Zip.Marks"})