I am revising some older documents to work out some bugs and I realized in one place I have two tables that should be one. The house different data so I am not trying to merge data but I should have added all of the columns into one data since every column is about a company. My pain is that one table has 63 columns and the other has 42 columns. So it is going to be a pain to add all of the columns from 1 to the other. The data is easy to copy & paste but setting up all the columns is my challenge.
Has anyone figured an easy way to do this or do I have to add column by column manually and they fix all the formulas? Is there a way to even just copy column titles to a new table in a way similar to copy and pasting columns?
Once I clean this up I will delete the unneeded table.
You could totally do it with formulas, but it’s going to need a lot of setup and some fancy formula writing skills, which I’m not exactly up for. Maybe you should check out using a spreadsheet? It’s especially handy since you only need it once.
To get around the problem, I’d just copy both tables into one spreadsheet, make the changes there. Then, I’d copy the updated, organized data back into Coda.
