# How to join data from two tables into a third **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2022, 1:08am UTC](https://community.glideapps.com/t/how-to-join-data-from-two-tables-into-a-third/55276 "2022-12-01T01:08:12Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)\ **Post date:** [December 1, 2022, 1:08am UTC](https://community.glideapps.com/t/how-to-join-data-from-two-tables-into-a-third/55276/1 "2022-12-01T01:08:12Z")
Working with a crowd sourced google Sheets spreadsheet as the main data source. Basically, tab 1 of the sheet is everyone who works in location 1 for the business and tab 2 is the same info for those who work in location 2. I can’t add sheets to the Sheets spreadsheet to use a function to join them, so I was hoping there was some way in a third table, a Glide Table, to basically merge the two sheets. My goal, ultimately is to display one unified collection, instead of two separate collections. Each row in the two sheets has a unique number, and I tried manually adding all of the numbers from the two sheets into row 1 of a glide table and then relating. But, of course, that didn’t work because I now have two rows, instead of two tables, but it didn’t get me closer to my goal. Thoughts on how/if this is possible? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [December 1, 2022, 1:53am UTC](https://community.glideapps.com/t/how-to-join-data-from-two-tables-into-a-third/55276/2 "2022-12-01T01:53:00Z")
Maybe this thread can help: [Concatenate columns](https://community.glideapps.com/t/collecting-all-dates-into-one-table-for-a-calendar/54941/12) (You might want to concatenate RowIDs)