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

On May 9, 8:14 pm, renu98 <hardeep.kan...@gmail.com> wrote:
> 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