Data Set is too big, so no example attached. But I think I can explain it.
My old data set, which is a TABLE, is 32 columns wide and 49552 rows deep. Now I want to paste in updated data.
I copy my new data, minus the headers.
I select the first row under my headers in my TABLE, and paste as values my new data, which is 32 columns wife and 67582 row deep.
My new data doesn't paste in the rows under the existing table. Though it has the shadow like I pasted there, the cells are empty. So I still have 49552 rows of data.
I tried copying just a few pieces of data, and pasting under the table, and it works fine.
However, if I copy a small set, like five rows, and paste by clicking into the last populated row of my TABLE, nothing gets pasted into the 4 rows below.
What am I doing wrong?
Bookmarks