copy rows based on input in columns

[ssuzzie]

Hello,
I have a below table:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Month x[/TD]
[TD]MONTH x+1[/TD]
[TD]Volume month x[/TD]
[TD]Volume month x+1[/TD]
[/TR]
[TR]
[TD]PRODUCT 1[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]100[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I would like to convert it to the following:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Month[/TD]
[TD]Volume[/TD]
[/TR]
[TR]
[TD]PRODUCT 1[/TD]
[TD]7[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]PRODUCT 1[/TD]
[TD]8[/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]

Is there any easy way to do this?

Thanks a lot

 

[ssuzzie]

Hi Joe, Thanks a lot! Indeed I changed sheets names and adjusted column numbers, it is working perfectly now!

 

[Joe4]

You are welcome.
Glad it worked out!