# Combine two tables together and have everything line up

**URL:** <https://community.parabola.io/t/combine-two-tables-together-and-have-everything-line-up/1948>\
**Category:** Ask a question\
**Created:** [July 28, 2021, 6:26am UTC](https://community.parabola.io/t/combine-two-tables-together-and-have-everything-line-up/1948 "2021-07-28T06:26:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Justin\_Saunders](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@Justin\_Saunders](https://community.parabola.io/u/Justin_Saunders)\
**Post date:** [July 28, 2021, 6:26am UTC](https://community.parabola.io/t/combine-two-tables-together-and-have-everything-line-up/1948/1 "2021-07-28T06:26:15Z")

</div>

I am trying to add a column back into a table with some data that has been extracted. See screenshot.

 ![Screen Shot 2021-07-28 at 15.57.25](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/3da62eb6581b1d428af6ff8b72fb885b61dd8014.png)

As you can see I have the last column with numbers I have extracted from rows 26, 29 and 34. I now need to move those three numbers to a new column indicated by the two black lines on the screenshot. I extracted the numbers by using an if/else command, indicating that if a specific word or group of words was in the second column then it extracts the number from the third column into a new column. My next line of thinking was to select the new column out, then remove the lines that I have scribbled out. After that I was trying to recombine the table and the column so that the numbers lined up with the cells as per the arrows on the screenshot. Any ideas on how I can do this? Currently if I do the combine tables it adds the new column onto the bottom of the table rather than inline with the table.

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [July 28, 2021, 10:57pm UTC](https://community.parabola.io/t/combine-two-tables-together-and-have-everything-line-up/1948/2 "2021-07-28T22:57:58Z")

</div>

Hey @Justin_Saunders,

Interesting use case! Sounds like you may be trying to join the tables on non-matching column values, and keeping all rows from both inputs.

First, can you try matching your data on a shared column value like the Row Number or Name? Next, I might suggest using a “Fill in blanks” step to fill in the cells using `values from above` or `values from below`.

Your new table should have the correct values duplicated throughout the column. Is filtering the rows based on the row number a viable solution to remove up the scribbled columns?

---

<div class="post-metadata">

**Author:** ![Justin\_Saunders](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@Justin\_Saunders](https://community.parabola.io/u/Justin_Saunders)\
**Post date:** [July 29, 2021, 12:38am UTC](https://community.parabola.io/t/combine-two-tables-together-and-have-everything-line-up/1948/3 "2021-07-29T00:38:17Z")

</div>

Hi @daniel ,

Thanks for your reply, I believe that is what I am trying to do. Think it would be nice to be able to add a blank column if needed. Anyway, you message got me thinking and I am unsure if this is what you were getting at, but I used the fill blank to fill the gaps under the data in the new column and then used an if/else action to select the correct row/cell for where I want that number to appear, places these in another new column. I then deleted the first column and shifted the new column to be the second column in the table. It seems to have worked for what I need. Thanks for your help.