6. Join or Merge Data Together

Now that you have all your individual data sources imported and formatted you can join them together into a single spreadsheet.

1. Starting with the phenotype spreadsheet go to File > Join or Merge Spreadsheets. Select the spreadsheet containing pedigree information and click OK. This will bring up the Join or Merge Spreadsheets window. Here you will specify how you want to join the two spreadsheets. The safest option is to join spreadsheet using row labels as matching criteria. If, for some reason, the two spreadsheets do not contain matching row labels, you can define a custom order.
2. Repeat this process by subsequently joining the spreadsheet containing genetic data with the first joined spreadsheet containing both pedigree and phenotype data.

Upon completion you will have a fully merged spreadsheet as in Figure 8.

Figure 8. Spreadsheet containing pedigree, phenotype, and genetic data