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.
Hi khat,
let
SampleSource = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRyNjQyNjFV0lEytDa1tlCK1YlWcvfwMje1sASKWVhbWhuaggV9/fxNjUzMQAoNrA2NrM2UYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
Split = Table.TransformColumns(SampleSource, {{"Column2", each Text.Split(_, ";")}}),
ExpandedSplit = Table.ExpandListColumn(Split, "Column2"),
MergedColumns = Table.CombineColumns(ExpandedSplit,{"Column1", "Column2"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Merged")
in
MergedColumnsIf you want to refer your data, delete this part and refer to your table (or previous step). Don't forget comma.