make rows and paste acording to a cellinfo

[nalle077]

I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html
and this is the continue of my macro which I believe has to change what I had help with yesterday .
Sorry for not thinking the whole thing through before posting
Here is what I want.
If anyone can help. Please if you want also explain so that I learn sometimes I do not understand what the VBA does even if it works
thanks in advance


[TABLE="width: 1200"]
<tbody>[TR]
[TD]From this.(here under) It may be 1,2,3 or more column and different info[/TD]
[TD][/TD]
[TD][/TD]
[TD]How many of each. This info is always in the most right column[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD][/TD]
[TD]B3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[TD]45[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]asd[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]This (here under) should be the result. The original info should be deleted[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]A2[/TD]
[TD]A3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD][/TD]
[TD]B3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD][/TD]
[TD]B3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD][/TD]
[TD]B3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[TD]45[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]asd[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]asd[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[nalle077]

Anyone who can help.
In the sollution in my other thread https://www.mrexcel.com/forum/excel-...tive-cell.html
It works if I do this on the end with one problem.
F5, Special, Empty cells, =A1, ctrl+Enter, mark all, copy, paste values
The result will be that it copies the cells over, and if there is a empty cell it takes the info from the first cell over which has info and copies that.
So the empty cells gets filled , which will be problem for me

 

[nalle077]

Is nobody able to help me with this.
Is something bad explained?