How to concatenate rows in excel?

Question

Macros

There is a similar table in Excel:

It is required that it would become like this:

Is it possible to do this?

Answer 1

1. If there are few positions - stupidly add a line above / below the group of lines that you need to "reduce", enter the formula for adding all the necessary lines above / below it into one cell, and stretch it horizontally.
Then select the line with the amounts, copy, paste as values. Now delete the extra lines.
2. The second option will require minor changes to the table - you will need to copy the months directly into the row above the data and use the Subtotal function (Subtotals) (for each customer, if there are several); if necessary, again, the result can be copied and pasted as values, you can get rid of extra lines or hide them:
There are other ways, using VBA, for example, or using Pivot, but here you have to look - depending on the amount of data being processed, the manual approach described above may be easier and faster to implement.
For example, Pivot will require some normalization of the original table: for each row, you will need to specify a customer. But then the data can be twisted and twisted as you like, by editing the table settings, or using slicers, highlighting only the buyers/products/months of interest/of interest. The result looks something like this:

Table