Hello,
Could you please help me figure out how to make xlookup (or perhaps other function) to match the Part ID and the Column Name and insert the appropriate Part Name into the Appropriate Column?

two way xlookup.JPG
Data
Part ID Part Name Column Name
710 US-MADAC-18M Evolution
710 BHMA18M-TF Eliminator TF
710 BHMA18M Eliminator BP
710 AG-MADAC-18M Channel Flow

Result
Part ID Evolution Channel Flow Eliminator BP Eliminator TF
710 US-MADAC-18M AG-MADAC-18M BHMA18M BHMA18M-TF

Thank you