Merge and Centre

R

renu98

This is my sheet

SLR NO. NAME POINTS REDEEM
POINTS TOTAL
001 HARDEEP 4500.00
2000.00 4500.00
002 HARDEEP 4500.00
2000.00 4500.00
003 JOHN 8500.00
1200.00 8500.00
004 WILLS 10500.00
5000.00 10500.00
005 WILLS 10500.00
5000.00 10500.00
006 DAVE 9500.00
4000.00 9500.00
007 DAVE 9500.00
4000.00 9500.00

And i Want like this

SLR NO. NAME POINTS REDEEM
POINTS TOTAL
001 HARDEEP 4500.00
2000.00 4500.00

003 JOHN 8500.00
1200.00
8500.00
004 WILLS 10500.00
5000.00 10500.00

006 DAVE 9500.00
4000.00 9500.00

Because this sheet has 1800 or more data some data has same and i want
to merge and centre the same data.

And after every 15 days i received this type of sheet and it is very
diffcult for me to merge and centre one by one
Any help will be appriciate

Thanks in Advance

Hardeep kanwar
 
R

renu98

This is my sheet

SLR NO. NAME POINTS REDEEMPOINTS TOTAL
001 HARDEEP 4500 2000.00 4500.00
002 HARDEEP 4500.00 2000.00 4500.00
003 JOHN 8500.00 1200.00 8500.00
004 WILLS 10500.00 5000.00 10500.00
005 WILLS 10500.00 5000.00 10500.00
006 DAVE 9500.00 4000.00 9500.00
007 DAVE 9500.00 4000.00 9500.00

And i Want like this

SLR NO. NAME POINTS REDEEMPOINTS TOTAL
001 HARDEEP 4500.00 2000.00 4500.00

003 JOHN 8500.00 1200.00 8500.00
004 WILLS 10500.00 5000.00 10500.00

006 DAVE 9500.00 4000.00 9500.00

Because this sheet has 1800 or more data some data has same and i want
to merge and centre the same data.

And after every 15 days i received this type of sheet and it is very
diffcult for me to merge and centre one by one
Any help will be appriciate

Thanks in Advance

Hardeep kanwar
Click to expand...

Still waiting for reply from ur side

Thanks

Hardeep Kanwar
 
Top