Find and Replace and Append New Columns

[pgvr]

Hi I have a data set with multiple columns which contains Players name , I need to get their DOB , Next to Players Name in each column

Have given just 3 column names , but in reality I got values for 12 sports and many rows of data

Is there a simple way of getting the output?

I tried Record ID,Transpose,Find n Replace , CrossTab, and got stuck..

Sheet 1 Column Names:

Basketball Player,Cricket Player,Football Player

Sheet 2 Column Names :

Player Name , DOB

Required Results

Basketball Player,DOB,CricketPlayer,DOB,FootBallPlayer,DOB

[Qiu]

@pgvr 

Some sample data would have been better, but I hope I get you right.