Example:

• Data:

• Excel by default if I merge columns by row

• Desired outcome

Above is an example, the amount of data I am working with involves a lot of columns, so it is not practical to merge and sum individually.

Am looking for a way to essentially combine 2 columns into one, and SUM those values up individually for each row.

CodePudding user response：

I would do a helper column with the sum, then copy pastespecial values in that helper column. Delete the original columns leaving the result.

CodePudding user response：

You can utilize copy and paste special method.

• Select B1:B3 and copy. For your real case select desired cells.
• Select A1:A3 and right click.
• Then select paste special and tick Add option.
• Hit OK