Hi guys, I am trying to move cells on the Product ID cells.
Here is the example of data and I would like to move HEIN4 move down 5 and go left 2. Then Move MC 3 down and 1 left.
So I would like to have an output like this. I have more than ten of this on a sheet, and HEIN4, MC could be named differently for the other part. But formatting(moving format) is same.
Is there any good way to format top of two cells on ProductID?
Anything helps!
Thank you!
Code:
[TABLE="width: 521"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]HEIN4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]MC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product ID[/TD]
[TD]Prdouct Group[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]426[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
Here is the example of data and I would like to move HEIN4 move down 5 and go left 2. Then Move MC 3 down and 1 left.
Code:
[TABLE="width: 521"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Product ID[/TD]
[TD]Prdouct Group[/TD]
[/TR]
[TR]
[TD]HEIN4[/TD]
[TD]MC[/TD]
[TD="align: right"]426[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
So I would like to have an output like this. I have more than ten of this on a sheet, and HEIN4, MC could be named differently for the other part. But formatting(moving format) is same.
Is there any good way to format top of two cells on ProductID?
Anything helps!
Thank you!