Joining Data

Question

Hi,

I have two Excel documents that I want to join together. In one Excel there is a Column with one security ID. In another Excel I have 5 columns with IDs (see sample attached).

I want to join the data together. Is there any way to look up across multiple columns or what is the best way to do this?

Any help on this would be much appreciated.

Many thanks.

IDs Sample.xlsx

FrederikE · Answer

Hey @furlonla,

See the attached example.

New Workflow1.yxzp

furlonla · Answer

Could you provide some more details on this please. I am not familiar with the transpose tool. Thanks.

FrederikE · Answer

Hey @furlonla,

The best way to handle this is to transpose the 5 columns into 1 and then perform the Join. Afterward, you can change it back to 5 columns again.