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.
Solved! Go to Solution.
Hi @mbrenn207
See my attached solution. First split the "name" column and then crosstab for the desired result above.
awesome. so simple of a solution. thanks for quick turnaround