Fli
05-02-2024, 10:01 AM
I had multiple columns of numbers and i wanted to remove one of the columns, but before its removal, i wanted to add/attribute its values to one of the existing columns.
How to do it? I have found one way (i will be explaining for Calc, but Excel may be similar).
It is about using new column that will consist of values of a column that i want to remove + values of a column of choice and then cut and paste new column over old column.
Legend for the following tutorial:
unwanted column = column that contains numbers which you want to remove and which data you want to add/attribute to other (wanted) column
wanted column = this column is wanted, but needs its values updated/increased by the values from unwanted column
new column = temporarily created column which values equals to wanted + unwanted
VIDEO (https://drive.proton.me/urls/ZH492QGAWR#rsttEmapaxxD)
1. click into a first cell of an empty new column and write: =SUM(
2. find a cell with a first number of the wanted column and mouse left click it
3. hit + key
4. find a cell with a first number of the unwanted column and mouse left click it
5. hit key ) and then Enter key to confirm
6. now you can verify that that the newly created cell equals to a SUMmary of the first row numbers of both summarized columns
7. If that is so, then while you are having activated the cell with this summary, you should see the + in the bottom right corner of this cell, hold left mouse button on the + and drag all the way down to the last row of the two columns you have summarized. The Calc/Excel will duplicate your summary for all rows.
8. Now you have three columns full of the data (numbers):
Wanted column
Unwanted column
Summary column ( Wanted + Unwanted )
9. Now lets replace Wanted column by the summarized data in Summary column:
- After you have backup file, you can highlight all the rows of the summary column (for example clicking first cell, scrolling all the way down, holding Shift and clicking the last cell). Ctrl+X to cut the data, Right click the first cell of the Wanted column and from the menu select to Paste special -> Number. Now you can remove unwanted column, since the wanted column now contains its values + its original values.
How to do it? I have found one way (i will be explaining for Calc, but Excel may be similar).
It is about using new column that will consist of values of a column that i want to remove + values of a column of choice and then cut and paste new column over old column.
Legend for the following tutorial:
unwanted column = column that contains numbers which you want to remove and which data you want to add/attribute to other (wanted) column
wanted column = this column is wanted, but needs its values updated/increased by the values from unwanted column
new column = temporarily created column which values equals to wanted + unwanted
VIDEO (https://drive.proton.me/urls/ZH492QGAWR#rsttEmapaxxD)
1. click into a first cell of an empty new column and write: =SUM(
2. find a cell with a first number of the wanted column and mouse left click it
3. hit + key
4. find a cell with a first number of the unwanted column and mouse left click it
5. hit key ) and then Enter key to confirm
6. now you can verify that that the newly created cell equals to a SUMmary of the first row numbers of both summarized columns
7. If that is so, then while you are having activated the cell with this summary, you should see the + in the bottom right corner of this cell, hold left mouse button on the + and drag all the way down to the last row of the two columns you have summarized. The Calc/Excel will duplicate your summary for all rows.
8. Now you have three columns full of the data (numbers):
Wanted column
Unwanted column
Summary column ( Wanted + Unwanted )
9. Now lets replace Wanted column by the summarized data in Summary column:
- After you have backup file, you can highlight all the rows of the summary column (for example clicking first cell, scrolling all the way down, holding Shift and clicking the last cell). Ctrl+X to cut the data, Right click the first cell of the Wanted column and from the menu select to Paste special -> Number. Now you can remove unwanted column, since the wanted column now contains its values + its original values.