How to copy data from one table to another without relation?

Question

Google Sheets

There is a table A in certain cells data is entered (for example, full name), it is necessary that they be copied to table B.
But so that when table A is deleted, the data is not deleted from B .
How to solve this problem? I tried different functions but they are all useless, because when you delete table A , the data disappears from B :(
google spreadsheet

Answer 1

What problem are you solving? Describe a normally solvable problem and you will be prompted for the optimal solution.
In Google spreadsheets, IMHO, you can't do that. Your data is accumulated in table 1, copied to table 2 (as I understand it, links to data from table 1 are not copied, but links to data from table 1 are inserted, otherwise they would not disappear during real copying - a copy is the same!)
Why not try other tools?
Try to solve the problem from the other end - save everything in A, which will be unchanged and make selections from it in B, then delete B.
In general, set a more specific task!

Answer 2

I have exactly the same task. In more detail, then here:
there is a daily report, it has a cell in which you need to insert weather conditions. On a separate sheet using parsing, I get data from the weather station website. On this sheet I find the necessary data in the form of precipitation. Now the most difficult thing is to copy this data into a cell in my report. If you make a link, then the next day the data will change, but I need the data to be relevant for every day. Those. I need the data that I received today from cell A1 to be copied to cell A2, but when the data in the first cell A1 changes, the data in the second cell A2 remains. I think I described it in sufficient detail.

Answer 3

If I understand the question correctly, then you can write a small script in which to insert the lines:
var SPREADSHEET_ID = 'copy here the key of table A';
var SHEET_NAME = 'write the sheet name in table A';
var dataSheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME);
// now we work with table A as if it were our own, for example
var sheet = SpreadsheetApp.getActiveSheet(); // current table B
var val = dataSheet.getRange(8,5).getValue(); // get the contents of the cell in the 8th row, 5th column (or "E8") in table A
sheet.getRange("A3").setValue(val); // put data into current open table B in 3rd row, 1st column (or "A3")
// now, regardless of the fate of table A, the data will remain in table B