NiladriACN
New Member
- Joined
- Mar 27, 2019
- Messages
- 3
Hi All,
This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below input and output table. Stored no is sorted as an order
Input Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Weighting[/TD]
[TD]Matrix[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]10[/TD]
[TD]ABC>10[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]15[/TD]
[TD]DEF = 15[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]27[/TD]
[TD]CDE <= 22[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]12[/TD]
[TD]ABC = 2[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]10[/TD]
[TD]DEF = 25[/TD]
[/TR]
</tbody>[/TABLE]
Output Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]weighting[/TD]
[TD]Matrix[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]52 (10+15+27)[/TD]
[TD]ABC > 10;DEF =15 ;CDE <=22[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]22 (12 +10)[/TD]
[TD]ABC = 2 ; DEF = 25[/TD]
[/TR]
</tbody>[/TABLE]
Is there any formula or code to solve this issue ? I have more than 10K rows so manually checking it's time consuming.
Please help!!
Regards,
Niladri
****** id="cke_pastebin" style="position: absolute; top: 322.667px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]ABC>10[/TD]
[/TR]
</tbody>[/TABLE]
</body>
This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below input and output table. Stored no is sorted as an order
Input Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Weighting[/TD]
[TD]Matrix[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]10[/TD]
[TD]ABC>10[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]15[/TD]
[TD]DEF = 15[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]27[/TD]
[TD]CDE <= 22[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]12[/TD]
[TD]ABC = 2[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]10[/TD]
[TD]DEF = 25[/TD]
[/TR]
</tbody>[/TABLE]
Output Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]weighting[/TD]
[TD]Matrix[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]52 (10+15+27)[/TD]
[TD]ABC > 10;DEF =15 ;CDE <=22[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]22 (12 +10)[/TD]
[TD]ABC = 2 ; DEF = 25[/TD]
[/TR]
</tbody>[/TABLE]
Is there any formula or code to solve this issue ? I have more than 10K rows so manually checking it's time consuming.
Please help!!
Regards,
Niladri
****** id="cke_pastebin" style="position: absolute; top: 322.667px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]ABC>10[/TD]
[/TR]
</tbody>[/TABLE]
</body>