Nov 01 2019 01:28 PM
Nov 04 2019 04:29 AM
You need to have ID:s in separate rows to merge. To do that add new column splitting your texts with comma separated ID:s into the lists in that column, after that expand it and do merging on this new column. Generated script looks like
...
//be sure the column has TEXT type
#"Changed Type" = Table.TransformColumnTypes(
Source,
{{"Requisitions", type text}}
),
// Add custom column splitting text to list
// using comma as delimeter
#"Added Custom" = Table.AddColumn(
#"Changed Type",
"Custom",
each Text.Split([Requisitions],",")
),
// expand new cusom column to rows
#"Expanded Custom" = Table.ExpandListColumn(
#"Added Custom",
"Custom"
),
// just in case trim it
#"Trimmed Text" = Table.TransformColumns(
#"Expanded Custom",
{{"Custom", Text.Trim, type text}}
)
...
Simple sample is attached.