Hey guys,
I'm trying to "transpose" a column based on 2 unique values and I'm having trouble figuring out how. I tried using index but after a couple hours i threw in the towel and resorted to seeking help here. I have attached an excel file as an example of what i'm trying to do and where i'm at. (i just made it up as an example).
Basically i want to move/copy the codes in column C and transpose it in rows given the unique "clientid" and "type"
Thank you for the help!
Bookmarks