Previous Topic Next Topic

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

Answer 1 / 1
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!
Ssuzzzie
Aug 29, 2018 at 04:26 PM
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

Similar discussions

Forgotten input phone lock code
jared -
closeup22 -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

4 responses
phone lock <SOS>
keary88 -
Ambucias -

1 response