Help! Re-organized table but forgot to connect column

[clopez174]

Hey everyone,

I feel so stupid for letting such a simple, but costly, mistake happen. I created a table and forgot to select a very important column when converting from range to table format. Now, I have reorganized all of my data and in order for me to get this back on track, I would have to individually copy and paste every label.

Is there any way to avoid doing this manually? I would like to reduce possible error on my part. I figured I should ask on here before heading into this troublesome journey. I do have the original table with all the columns connected, is there any way to connect cells based on several cell values? (like if 1 sheet has 2 cells which match in the same row, generate a cell from a locked column within that same row and input it into another cell within another sheet?). I don't really know if this is possible. Any help would be appreciated.

[Pete_UK]

It would help if you attached a sample file (or the real one if it is not very big and does not contain confidential data), along with the original table. The yellow banner at the top of the screen explains how to do this.

Pete

[FDibbins]

If you have omitted a column, then sorted the rest of the data, then I have a feeling you are going to be SOL. Did you save the file before you started playing around? If so, maybe you could recover that way?