Forum Discussion
Solved
Formatting part numbers
I need to format some part numbers in Power Query but can't figure out how to do it in an automated way. This is what the raw data looks like: This is how I need it to look: S...
use 'split column by delimiter' and (in the advanced section) choose 'To rows'.
After that, you can Merge the columns.
let
Source = your_raw_table,
rows = Table.ToRows(Source),
to_list = List.TransformMany(
rows,
(x) => Text.Split(x{1}, ";"),
(x, y) => {x{0} & "-" & y}
),
to_tbl = #table({"desired format"}, to_list)
in
to_tbl
Dumb question here: do I create a new column and put the suggested code in there? Unsure of the first step.