The piece I am really struggling with is the comma delimited split. This is the order as done in power query.


Select entire tab/Table


Source = Excel.CurrentWorkbook(){[Name=“Table1”]}�Content],


#“Changed Type” = Table.TransformColumnTypes(Source,{{Many Columns/Fields}}),

Select only the Columns/Fields


#“Removed Other Columns” = Table.SelectColumns(#“Changed Type”,{“Key”, “ManyLinked”}),

Remove empty cells/rows


#“Filtered Rows” = Table.SelectRows(#“Removed Other Columns”, each (RManyLinked] <> null)),

Split the ManyLinked into one row for each comma delimitate value - each row gets the value from Key and a single value from ManyLinked


#“Split Column by Delimiter” = Table.ExpandListColumn(Table.TransformColumns(Table.TransformColumnTypes(#“Filtered Rows”, {{“ManyLinked”, type text}}, “en-US”), {{“ManyLinked”, Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta tSerialized.Text = true] in type {itemType}}}), “ManyLinked”),

Thanks, Teri