# Blending the Data

To demonstrate how the data blending works, we'll use two data sources: Airtable and Google Sheets, where the former contains the `Order` table and the latter - the `Customers` table. Notice that the `Customer ID` column in the `Orders` table refers to the `ID` in the `Customers` table.

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FS9RdU4tCDHx2B0RKyb7n%2Fdtzhy.png?alt=media\&token=8f83cd64-df0a-435c-b7dd-166a2c5464b6)

Once you've connected your data sources (read more on particular integrations [**here**](https://docs.jetadmin.io/user-guide/integrations)), proceed to the data section and pick a data source where you want to perform the blending *(you can choose either one, it's just a matter of convenience)*

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FRdrQQSriYqs7ggBKpTWB%2Fdhtffyu.png?alt=media\&token=20ca9b10-abc1-49a0-8a08-c8404f41f9cb)

1. Create a new **Virtual Collection**
2. Name the Collection
3. Click on the `Create` button
4. You'll see all the data sources you've connected using "Sync" on the right. You can now pick the columns and use them in your query:

{% @arcade/embed flowId="fHlP2za57Nst2y8C1fW6" url="<https://app.arcade.software/share/fHlP2za57Nst2y8C1fW6>" %}

And after writing and running our query, we get the resulting table, containing `Full name` and `Country` columns from the `Customers` table together with the `Order Date` column from the `Orders` table.

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2Ft1tiQ3tDc1WlCe4A3YCp%2Frdzhxgtd.png?alt=media\&token=55bd9623-8acd-48f2-b6c1-d10c7b44f334)

After saving changes, we get a collection with joined data that we can later use in the interface.