Use this page to quickly and efficiently perform useful table operations such as:

  • Merging 2 tables with different numbers of rows
  • Adding information to MyTable using information from the Lookup Table
  • Use the find (column 1) and replace (column 2) of the Lookup Table to change entries in MyTable

Paste MyTable in text box below:

Paste the Lookup Table (first column contains the 'Key' word) in text box below:

Align Tables on the basis of the first column
Align Tables on any column of MyTable and the first column of the lookup table
Use the find (column 1) and replace (column 2) of the Lookup Table to change entries in MyTable