Grouping/splitting column when unique ID matches

[jcastr02]

See below  and appreciate your help.  Essentially what I am trying to do is sort of pivot the Work order tag reason column / split it when the work order number matches.  Need to do this somehow within transforming data

[amitchandak]

@jcastr02 , Unpivot with Max in place of count.

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/