Joining Data

[furlonla]

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.

[FrederikE]

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. 

[furlonla]

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

[FrederikE]

Hey @furlonla,

See the attached example.