Data pasted into Numbers copied from Google Sheets is getting transposed and missing

This is at least the third time in about two weeks that someone has reported this issue in this forum. Someone had success passing data to Excel before shipping it to Numbers, but that's an unpleasant workaround. Let's hope Apple soon fixes the clipboard glitch in an update (or let Google know that a new protocol has been established).

As for what you reported in your update, the reason is very simple: you pasted in a cell that was in edit mode, i.e. the cursor was flashing in it. You can do that within Numbers, no need for external data.

Copy-pasting from a Google Sheet to Numbers does seem to give unexpected results on my machine too.

Try selecting the cells in Google Sheets, command-c to copy, click on the canvas of a sheet in Numbers (i.e not in the cell of an existing table , and command-v to paste. That should create a new table. From there you can copy-paste elsewhere if needed.

SG

Thanks, this was helpful. the other think I tried and worked was copy in Google Sheet and Past on Icloud numbers, then copy from there and past it in the Numbers App.