Transpose data

Hello,

I have been assigned an urgent task this morning and would need some help.

I have a huge table as show below;Attachment 633127

I would like to amend asAttachment 633128

I am actually placing the connection into a column and fill the correspondent details, buy using Index Match function =INDEX(FCB[depdesc],MATCH(1,(A3=FCB[code])*($D$2=FCB[source]),0) with CSE but since table contains about 150,000 row it's taking ages to complete.

Any suggestion or ideas how I could speed and improve?

Thanks in advance