Create rows based on input in columns

Registration date
Wednesday August 29, 2018
Last seen
August 29, 2018
I have a below table:

And I would like to create the following automatically:

Is there any easy way to create it?

Thanks a lot
See more 

Your reply

1 reply

Registration date
Monday June 3, 2013
Last seen
January 22, 2019
Thank you
Create it when? Is each line entered one at a time, or is the whole sheet formatted with dozens of lines, and you want the cell to insert a row and paste? Your description lacks a lot of details, to include how the sheet is created, and when you want this action to take place!
Thanks for ur response. I have simplified the example. In the file I have many lines with different products and about 22 columns (until month +10). I wd like to convert it in a smaller table to have a line per each product and month with a respective volume, in a new sheet. I will send another sample to make it clear. Thanks a lot for ur help
Respond to ac3mark