How to combine two excel spreadsheets with different column headers?

[atarahoward]

Hello! I am trying to figure out how to combine report 2 data into report one but the column headers are different between the two reports. For example, I want to pull put the "Sales Document" data from Report 2 into the "Sales Order Num" column in Report 1.

[ChrisTX]

You can use a Select tool to manually re-name columns, then a Union tool to combine the two data streams.

Or to fix the column names using a macro, check out this example: Design Pattern – Easily changing field names – Alter Tricks

Chris

[nagakavyasri]

Try this by joining