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.

[kathleenmonks · Accepted solution]

Hi @mbrenn207 

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

[mbrenn207]

awesome. so simple of a solution. thanks for quick turnaround