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.