Complete the following steps to merge worksheets side-by-side.
Use the right arrow to move the worksheets from Available worksheets to Worksheets to merge. Use the up and down arrows to change the order of the columns in the new worksheet.
In New worksheet name, enter a name for the new worksheet.