Data modification help needed

mbrenn207

hi - i have a raw data file where multiple attributes for the same ticket #  are displayed on unique rows (e.g. Name and Value) as shown below: 

I would like to modify the layout to the example show below where each Ticket has only 1 row for each STB (identified under Name column "STB1/STB2/STB3/etc):

raw data attached for reference. any help on how to accomplish this is appreciated.

Test input.xlsx

kathleenmonks

Hi @mbrenn207 

See my attached solution. First split the "name" column and then crosstab for the desired result above. 

solution.yxmd