I can't transpose in numbers for mac

I've figured out a workaround to this mysterious problem. It comes back as soon as I save the document in a shared folder.

Exported as .xlsx in a local folder > opened the .xlsx in Numbers > saved as .numbers in a local folder

Transpose was working.

Once I've moved the new .numbers document again to the shared folder Transpose stopped working again.

Are the values in the non-transposable table entered directly, or are they imported from one or more other tables in the document?

Not sure what you mean by imported, but the table was written from scratch and two columns are referencing two columns from another table.

Are the cells on the non-transposable table referenced by cells on one or more other tables?

Two of the columns reference data in one other table in another sheet. Although, deleting those columns doesn't fix the problem. I've double checked for any other formula in the current problematic sheet.

Are any of the inter dependent tables Locked?

All data is unlocked. To make sure I've gone through all the sheet pressing ⌘ + A and then ⌥ + ⌘ + L to unlock any rogue cell/table.

Adding to SG's suggestion to 'restart your Mac', I would take the next step—a restart into Safe Mode.

Details can be found here: How to use safe mode on your Mac - Apple Support (CA)

A restart into Safe Mode seems a bit drastic given that the menu options works fine in another document. Also MacOS seems to be working just fine overall. Apart from Numbers, I consider myself a power user, and I can usually tell when something is off.

The only other thing I can think of right now, is that this table was originally a ".csv" file, then opened in Numbers app, converted and saved with .numbers extension. I've never had any problems before with this kind of conversion.

Below more pictures of the table:

Thanks for this. I am pretty sure I do not have any pivot table active at the moment. How can I check that there is not any pivot table active across the sheets?

Nevertheless, I do not think that's the issue.

Just tried all of the above and it did not help. The only thing that enables Transpose is to create a new document and paste the table over there. Which is a massive headache since I need the sheets to be interconnected via formulas.

Is there a way to Pivot the table and maintain text instead of converting all values to numbers?

It’s not clear whether you have actually tried the suggestions to restart.

I did restart the Mac, just not in Safe Mode.

Here are the results of a restart in Safe Mode.

I've just tried opening the old .xlsx document (sorry I thought it was a .csv!) with Numbers, and opening it from scratch doesn't return the aforementioned problem with Transposing. Although the old table doesn't have any of my new entries in it... So this just confirms that the document with my new entries in particular.

How do you suggest I go about this? Apart from other troubleshooting, which I'd be happy to attempt, how can I re-build my data in a new .numbers document without loosing cell referencing?

Can custom fonts cause this kind of issue?

Thanks! I've checked all the sheets and there's no Pivot Table active anywhere in the document...