Pasting Data Across Spreadsheets Nightmare

I suspect you are selecting more than one cell in the table you are pasting into. If you select a range of cells to paste into, it will paste into only those cells (and will paste into all those cells) and might repeat data or not paste all the data or both.

1. In the imported document select and copy all the cells.
2. In the document with the formulas, select a single cell (one click, not two) and Paste. All of the data will be pasted and the table will expand as necessary to take it all.

You might want to consider one of the drag-drop import methods mentioned in my previous post so you don't need to do any copy/pasting; you can import directly into your document that has the formulas.

It depends on what source your bank statement is in. If it is a properly formed table from a web site, then you select the table data, copy to the clipboard, and by clicking once in the first repository cell of Numbers, you then paste and let Numbers automatically populate the cells, rows, and columns it needs to accommodate that data.

If that web table is not an HTML table but one done solely using CSS3 styling, then Numbers may not be able to deal with that type of content.

And if you are working from a data table in a PDF, just select the table contents, copy to clipboard, and then follow the cell selection and paste from the first paragraph.

With 1600 cells you may need to do this in stages of selected source cells.

Below are some methods for importing CSV data into a Numbers document. I misread your problem thinking this was it but it sounds like it imported correctly; it is the process of copying it from the newly created document to your other document that is the problem. See my next post about that.

A CSV file in Finder that is opened using Numbers will create a new Numbers document with one table on one sheet that has the correct number of columns and rows for all the data and no extra rows or columns. It does not involve any copying or pasting.

A CSV file that is drag-dropped to an empty place on a Numbers sheet will create a new table that has the correct number of columns and rows for all the data and no extra rows or columns. It does not involve any copying or pasting.

A CSV file that is drag-dropped from Finder onto an existing Numbers table will import the data into the table and will add the necessary number of columns and rows. If drag-dropped onto a table that is already populated with data, the new CSV data will be placed below all existing data. No copying or pasting is involved.

If a CSV file in Finder is copied then pasted into a single selected cell in a Numbers table, the CSV file will be pasted into the table starting at that point. The table will expand if necessary.

If a CSV file in Finder is copied then pasted into a Numbers table where all the cells have been selected, the CSV file will be pasted into the table and, if there are additional empty cells in the table, data from the CSV file will get repeated to fill the entire table.

If a CSV is opened in TextEdit and the contents copied then pasted into a selected cell in a Numbers table (selected with a single click, not two), it will usually import it as "table data" and put everything in the correct columns. But sometimes it does not recognize it as "table data" and may use only one column.

I'm sure there are other variations. If one of these methods does not work, it may be a problem with the CSV file.