Combining Data from Two Tables Side by Side in Excel | Clay

Combining Data from Two Tables Side by Side in Excel

Hey Guys, quick question, I have two tables both have 64 rows, I am trying to combine their data in third table side by side using ''write to table'' function . Let's say table 1 has column A,B,C and table 2 has columns D,E,F. When I write them to the third table the values of table 1 start from row 2 in table 3 and the values of table 2 start from row 66 however I want them side by side in the same row. How to resolve this issue?

5 comments

Clay
APP
·
·
The write to table function creates new rows for each source table rather than combining data side by side. To merge data from two tables horizontally, you need to use a different approach. First, transfer data from both tables to your third table using write to table's column mapping feature - enter "/" to skip list selection and map columns directly. Then use our Merge Columns feature to combine the data horizontally: click Add Column, select Merge Columns, and input your formula to combine the desired columns from both source tables. This two-step process will give you the side-by-side data layout you're looking for.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Table [Clay 101] - Clay University
Ahmer M.
·
·
I'm not sure how this can be done using merge columns feature
Clay
APP
·
·
The merge columns feature combines data from existing columns within the same table, not for joining separate tables side by side. For your use case with two 64-row tables, you need a different approach: 1. Use write to table to transfer data from Table 1 (columns A,B,C) to Table 3 2. Use write to table again to transfer data from Table 2 (columns D,E,F) to the same Table 3, mapping to different columns 3. Enter "/" to skip list selection and map columns directly This creates one table with all six columns (A,B,C,D,E,F) with matching row data side by side.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Write to Other Table | Documentation | Clay University
Ahmer M.
·
·
It didn't work
Ahmer M.
·
·
https://app.clay.com/workspaces/267186/workbooks/wb_0t0uydoQWqZ9n6Ng37d/tables/t_0t12lq9bjwpCsfap6aP/views/gv_0t12lq9oESdvUZGT35A