Look up problem

[Perch]

hello

got a bit of a problem with some look up data I don't know how to solve . Basically I have rows of data that repeats every now and again and codes next to them
What I need to do is have same row of data ( without it repeating ) and relevant codes next to these across the page
Tried doing Pivot table and failed

Example and proposed format enclosed

please can anyone help ?

thank you