Create rows based on input in columns

ssuzzzie
Posts
1
Registration date
Wednesday August 29, 2018
Last seen
August 29, 2018
- Aug 29, 2018 at 12:44 PM - Latest reply:  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
See more 

Your reply

2 replies

ac3mark
Posts
10845
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 14, 2018
- Aug 29, 2018 at 04:02 PM
0
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