Hi there,
i have attached a sample excel showing what I need help with....i am trying to extract the company names for positions 0,1 and 2 below in grey.......

what i need is to produce a table below in green showing each id's and there associated company name for positions 1,2 and 3 respectfully...

..attached is sample excel to help......any help for me on this would be great 