How to automate text parsing in excel cells?

Question

Automation

Hello, I have a spreadsheet in excel.
The first cell contains two parameters, the second cell contains the third parameter.
See figure "excel-was-min.jpg". Those. I mean, for example, cells A55 and B55, A57 and B57, A59 and B59.
Please tell me, an example of a macro that makes 3 empty cells on the right and transfers values ​​from the first 2 cells to each. Those. so that the result is,
as in the figure "excel-became-min.jpg".
---"excel-before-min.jpg"---

---"excel-before-min.jpg"---

Answer 1

The macro will affect the original table. After all, two lines are allocated for each record (event), and the result should be one. Thus, the original data (half) will be lost when the macro deletes every other line. Here it is better to use formulas and then copy the resulting table somewhere (if needed, for example, for printing). If it is necessary as a data source, then you can ignore the empty lines.