Transforming one large column into multiple distinct columns based on a third column

Hey I've ran into a situation where I need to pivot a grouping column and the relevant data should be grouped based on that. I'm trying to group display value by row number but it's not working as I...