Migrating Large Data Set to One Sheet

[Phishdawg]

Edit 2
Control of data returned once I upload to server and was using Excel Online. Are the two related? I do not know; But its working now.

Edit (Updated Content)-
I figured it out; I've gotten all the data to move over to one sheet. I've made it all a table.

Now, I lack control of the data; I can't change the column format type, change the alignment, and other standard function and settings.

I've tried to add a formula; All it did was replicate the formula.

[#2]

@Phishdawg 

It might be possible that the issue is related to using Excel Online.

Have you tried opening the file in the desktop version of Excel to see if the problem persists? Sometimes there can be differences in functionality between the online and desktop versions of Excel.

If the problem persists in the desktop version, you can try clearing the cell formatting or changing the formatting.

I hope this helps!