ulycalapuz
New Member
- Joined
- Dec 17, 2017
- Messages
- 2
SHEET 1
[TABLE="width: 250"]
<tbody>[TR]
[TD="align: center"]GIVEN[/TD]
[TD="align: center"]ITEMS[/TD]
[TD="align: center"]PACKING[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]APPLE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]ORANGE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]BANANA[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]GRAPES[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]WATERMELON[/TD]
[TD="align: center"]25 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]STRAWBERRY[/TD]
[TD="align: center"]30 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]PINEAPPLE[/TD]
[TD="align: center"]40 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]MANGO[/TD]
[TD="align: center"]10 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]POMEGRANATE[/TD]
[TD="align: center"]5 KGS[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2 - HOW I WANT IT TO BE:[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]GIVEN[/TD]
[TD="align: center"]ITEMS[/TD]
[TD="align: center"]PACKING[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]APPLE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]BANANA[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]GRAPES[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]PINEAPPLE[/TD]
[TD="align: center"]40 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]POMEGRANATE[/TD]
[TD="align: center"]5 KGS[/TD]
[/TR]
</tbody>[/TABLE]
I would like to make a formula without using VBA where I can automatically copy all given row with number value and skip blanks and copy it's column b and c at the same time also.
Thank you in advance.
[TABLE="width: 250"]
<tbody>[TR]
[TD="align: center"]GIVEN[/TD]
[TD="align: center"]ITEMS[/TD]
[TD="align: center"]PACKING[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]APPLE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]ORANGE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]BANANA[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]GRAPES[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]WATERMELON[/TD]
[TD="align: center"]25 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]STRAWBERRY[/TD]
[TD="align: center"]30 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]PINEAPPLE[/TD]
[TD="align: center"]40 KGS[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]MANGO[/TD]
[TD="align: center"]10 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]POMEGRANATE[/TD]
[TD="align: center"]5 KGS[/TD]
[/TR]
</tbody>[/TABLE]
SHEET 2 - HOW I WANT IT TO BE:[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]GIVEN[/TD]
[TD="align: center"]ITEMS[/TD]
[TD="align: center"]PACKING[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]APPLE[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]BANANA[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]GRAPES[/TD]
[TD="align: center"]20 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]PINEAPPLE[/TD]
[TD="align: center"]40 KGS[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]POMEGRANATE[/TD]
[TD="align: center"]5 KGS[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.
