Joining Data in 2 worksheets with same column names

I have 2 excel worksheets as inputs I am trying to join on same key element. These two have exactly same number of rows and same column headers. I need to compare the values of each column for both data inputs. For this I need the same columns to be placed next to each other. for example, the 2 sheets have columns as field1, field2, field3.. field 100. and workbook 2 has same fields field1, field2, field3.. field 100. i need my output to have columns as field1, field1_right, field2, field2_right, field3, field3_right... and so on.

Accepted answers

NickSm

@AashimaS

Sounds like you'd just want to use a Join tool and select to join by record position, but could also join by common ID. You can then rearrange the field order down below.

All comments

NickSm

@AashimaS

Sounds like you'd just want to use a Join tool and select to join by record position, but could also join by common ID. You can then rearrange the field order down below.

AashimaS

on a common id. there are 115 columns. by default the join output, gives in 115 records from the first excel and appending the columns from the second excel as right_column nam. so the output has 230 columns, which is correct. But I need the positioning of columns to be next to each for each same column name. col1,right_col2, col2, right_col 2.. etc.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703