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

Still waiting for reply from ur side

Thanks

Hardeep Kanwar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top