Create rows based on input in columns

Closed
ssuzzzie Posts 1 Registration date Wednesday August 29, 2018 Status Member Last seen August 29, 2018 - Updated on Aug 29, 2018 at 05:02 PM
 Ssuzzzie - Aug 29, 2018 at 04:26 PM
Hello,
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

1 response

Blocked Profile
Aug 29, 2018 at 04:02 PM
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!
0
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
0