Delete Duplicates values in row and transfer to new excel sheet

poonamSS

New Member
Joined
Sep 12, 2021
Messages
9
Office Version
  1. 2013
Platform
  1. Windows
Hello

Please help me VBA
Sr.No.Total Link loanLoan_NoMonth of Cases13/2 Notice Date13/2 Notice Dispatched DateDPD_13th JulyLink_SingalUnique IDLRN DateCustomer_Name 1Customer_Add-1Co_app_1 NameCo_app_1 AddressCo_app_2 NameCo_app_2 AddressCo_app_3 NameCo_app_3 AddressCo_app_4 NameCo_app_4 AddressCo_app_5 NameCo_app_5 AddressCo_app_6 NameCo_app_6 AddressCo_app_7 NameCo_app_7 AddressCo_app_8 NameCo_app_8 AddressCo_app_9 NameCo_app_9 AddressGar_1 NameGar_1 AddressGar_3 NameGar_3 Addressproperty address_1property address_2property address_3Amount FinanceAmount Finance in wordNPA datePrincipal OutstandingPending Installment InterestInterest till date of PrepaymentLate Payment Penalty ChargesCheque Bouncing ChargesOther ChargesPrepayment Charges @ 4.72 %on Outstanding PrincipalRefund, If AnyTotal Amount PayableTotal Amount Payable in wordsFC Date
126477143Aug-2126-Aug-21189Link5244449-Dec-19RITU GOELHOUSE NO 298/A NEAR AJABPUR RAILWAY CROSSING MADERSE WALI GALI AJABPUR KHURD AJABPUR DEHRADUN-248001ARVIND KUMAR GOELHOUSE NO 298/A NEAR AJABPUR RAILWAY CROSSING MADERSE WALI GALI AJABPUR KHURD AJABPUR DEHRADUN-248001All the Property bearing Municipal no 67/2(Old Municipal no 180), Dharampur-II Dehradun forming part of Khasra No. 466/2 Min Situated at Mauza Dharampur, Pargana Central Doon , Distt- Dehradun measuring 56.37 sq. Mts. Out of Which Covered area is 40 St. Owned by Shri Arvind Kumar Goyal Son of Late Shari Jetendra Kumar Goyal Duly registered in the office of the sub-Registrar, Dehadun in book no. 1 Volume 5230 on pages 71 to 98 at serial no 483 dated 17.01.2014 . Property Bounded as:- North-Property of Shri Arvind Kumar Goyal, Side measuring 60.8ft,south-partly Property of Smt. Praveen Sahani and Partly land of Smt. Kala. , East-20 Feet Wide Road, Side measuring 25 ft 6 inch, WEST- Property of Shri Jammudin, Side mesuring 29 feetAll the Property bearing Municipal no 67/2(Old Municipal no 180), Dharampur-II Dehradun forming part of Khasra No. 466/2 Min Situated at Mauza Dharampur, Pargana Central Doon , Distt- Dehradun measuring 157.7 sq. Mts. . Owned by Shri Arvind Kumar Goyal Son of Late Shari Jetendra Kumar Goyal Duly registered in the office of the sub-Registrar, Dehadun in book no. 1 Volume 5309 on pages 119 to 144 at serial no 1846 dated 05.03.2014 .Property Bounded As:-North-Property of Shri Kewal Chand Sahanil, Side measuring 60.8ft, , South- Property of Shri Girish Chand Sahani, Side measuring 60ft.8inches., East- 20 Feet Wide Road, Side measuring 10 ft , West-Property of Shri Jammudin, Side mesuring 10 feet9000000Rupees Ninety Lakhs Only5-Apr-21########535,065.0026,282.53428,294.0018,585.004008,001,023.53Rupees Eighty Lac One Thousand Twenty Three and Fiffty Three Paisa Only8/17/2021
222340021Aug-2126-Aug-2169Link635055NARAJASTHAN TEXTILESF-1 FIRST FLOOR PLOT NO 142-A JAIPUR-302002ROOP SINGH CHAUHANF-1 FIRST FLOOR PLOT NO 142 A JAIPUR-302002MANOHAR KANWARF-1 FIRST FLOOR PLOT NO 142 A JAIPUR-302001All the piece and parcel of the FLAT NO.F-1, FIRST FLOOR, P.No.142-A, GOVIND NAGAR WEST, AMER ROAD, JAIPIUR, RAJASTHAN. ADMESURING FLAT AREA 963 SQ. FEET. North:p.No.143 South:p.No.142 East:-Road West:-Other1096969Rupees Ten Lakhs Ninety Six Thousand Nine Hundred Sixty Nine Only3-Jun-21933,641.383,624.348,803.0011,505.005,199.9744,067.871,006,841.56Rupees Ten Lakhs Six Thousand Eight Hundred Forty One and Paise Fifty Six Only8/17/2021
31699135Aug-2126-Aug-2169Link635055NAROOP SINGH CHOUHANF-1 FIRST FLOOR PLOT NO 142-A GOVIND NAGAR WEST AMAR ROAD JAIPUR-302001MANOHAR DEVIF-1 FORST FLOOR PLOT NO 142-A GOVIND NAGAR WEST AMER ROAD JAIPUR-302001All the piece and parcel of the FLAT NO.F-1, FIRST FLOOR, P.No.142-A, GOVIND NAGAR WEST, AMER ROAD, JAIPIUR, RAJASTHAN. ADMESURING FLAT AREA 963 SQ. FEET. North:p.No.143 South:p.No.142 East:-Road West:-Other2491086Rupees Twenty Four Lakhs Ninety One Thousand Eighty Six Only3-Jun-21########50,393.975,456.4619,171.0011,505.005,197.831,498,509.08Rupees Fourteen Lakhs Ninety Eight Thousand Five Hundred Nine and Paise Eight Only8/17/2021
421376853Aug-2126-Aug-2199Link731431NAM/S TRIMURTI GRAM UDYOG SAMITITALWANDI BHANGERIAN DISTT MOGA MOGA-142001PARMOD CHANDER GOYALH NO 105 W NO 02 FRIENDS COLONY MOGA-142001ALKA GOYALH NO 105 WARD NO 2 FRIENDS COLONY MOGA-142001CHAMAN LAL GOYALH NO 105 WARD NO 2 FRIENDS COLONY MOGA-142001All the Piece and Parcel of the Property measuring 1 Kanal 0 Marlas 2 Sarsai=182/3195 Share of Land 17 Kanal 15 Marlas bearing Khasra No-2255(4-9), 2257(6-13), 2256(6-13), Khewat No-334, Khatauni Number-376,377 as per Jamabandi for the year 2007-2008,Situated at Moga Mehella Singh 111 Tehsil and District Moga as per Sale Deed bearing Wasika No-4297 Dated 21-8-1972 recorded in the name of Chaman Lal S/O Pyare Lal registered with Sub Registrar-Moga, Property Bounded as:- North-Babu Ram Bansal, South-Bachan Singh etc.,East-Dwarka Dass-Joginder Mall, West-Thakur Singh etc.3841834Rupees Thirty Eight Lakhs Forty One Thousand Eight Hundred Thirty Four Only3-Jun-21########10,470.6327,779.0012,368.00600127,310.860.672,875,791.84Rupees Twenty Eight Lakhs Seventy Five Thousand Seven Hundred Ninety One and Paise Eighty Four Only8/17/2021
51806710Aug-2126-Aug-21130Link7314318-Feb-21PARMOD CHANDER GOYALH NO 105 WARD NO 2 FRIENDS COLONY MOGA-142001MAYA DEVI GOYALH NO 105 W NO 02 FRIENDS COLONY MOGA-142001CHAMAN LAL GOYALH NO 105 WARD NO 2 FRIENDS COLONY MOGA-142001ALKA GOYALH NO 105 W NO 2 FRIENDS COLONY MOGA-142001All the Piece and Parcel of the Property measuring 1 Kanal 0 Marlas 2 Sarsai=182/3195 Share of Land 17 Kanal 15 Marlas bearing Khasra No-2255(4-9), 2257(6-13), 2256(6-13), Khewat No-334, Khatauni Number-376,377 as per Jamabandi for the year 2007-2008,Situated at Moga Mehella Singh 111 Tehsil and District Moga as per Sale Deed bearing Wasika No-4297 Dated 21-8-1972 recorded in the name of Chaman Lal S/O Pyare Lal registered with Sub Registrar-Moga, Property Bounded as:- North-Babu Ram Bansal, South-Bachan Singh etc.,East-Dwarka Dass-Joginder Mall, West-Thakur Singh etc.7632656Rupees Seventy Six Lakhs Thirty Two Thousand Six Hundred Fifty Six Only3-Jun-21########16,484.3481,420.0014,134.009620.144,359,413.88Rupees Forty Three Lakhs Fifty Nine Thousand Four Hundred Thirteen and Paise Eighty Eight Only8/17/2021
621324583Aug-2126-Aug-21130Link118190222-Nov-20MAHALAXMI PLASTICS AND ENGG WORKSPLOT NO 125 GROUND FLOOR POKET-I SECTOR 4 BAWANA DELHI-110039GEETA NARULAB 611 BLOCK B SUDARSHAN PARK NEW DELHI-110015BHOLA RAMB 611 BLOCK B SUDARSHAN PARK NEW DELHI-110015RAJESH NARULAB 611 BLOCK B SUDARSHAN PARK NEW DELHI-110015All that Piece and Parcel of the Property bearing B-611, built on Ahata no.-7A, land measuring 100 sq. yds., out of khasra no.2976/631 & 605, Village- Basai Darapur, Sudershan Park, New Delhi-1100157230704Rupees Seventy Two Lakhs Thirty Thousand Seven Hundred Four Only3-Jun-21########18,836.7249,067.0011,483.0030,999.30257,811.975,830,315.92Rupees Fifty Eight Lakhs Thirty Thousand Three Hundred Fifteen and Paise Ninety Two Only8/17/2021
719949684Aug-2126-Aug-2169Link118190222-Nov-20MAHALAXMI PLASTICS AND ENGG WORKSBASEMENT AND GROUND FLOOR I-55 SECTOR-2 DSIIDC BAWANA INDUSTRIAL AREA DELHI-110039 NEAR NAHAR DELHI-110039BHOLA RAMB-611 SUDERSHAN PARK RAMESH NAGAR RAMESH NAGAR RAJOURI GARDEN DUA ATA CHAKKI DELHI-110015RAJESH NARULAB-611 SUDERSHAN PARK RAMESH NAGAR RAMESH NAGAR RAJOURI GARDEN WEST DELHI NEAR DUA ATA CHAKKI DELHI-110015GEETA NARULAB-611 SUDERSHAN PARK MOTI NAGAR RAMESH NAGAR DUA ATA CHAKKI DELHI-110015All that Piece and Parcel of the Property bearing B-611, built on Ahata no.-7A, land measuring 100 sq. yds., out of khasra no.2976/631 & 605, Village- Basai Darapur, Sudershan Park, New Delhi-1100151580738Rupees Fifteen Lakhs Eighty Thousand Seven Hundred Thirty Eight Only4-Dec-20########2,853.905,544.508,197.0011,505.001,000.0075,883.821,713,036.22Rupees Seventeen Lakhs Thirteen Thousand Thirty Six and Paise Twenty Two Only8/17/2021
821352686Aug-2126-Aug-21250Link12069697-Feb-20PRADEEP AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SUNIL AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SANJEEV AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SURDEEP AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033BHARAT AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033RAJEEV AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SANGEETA AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033UNIQUE AGARSONS INDIAPLOT NO. 186 PHASE IV SECTOR-57 HSIIDC INDUSTRIAL ESTATE KUNDLI SONEPAT-131028SUNIL AGGARWALD-42 HAKIKAT RAI ROAD ADARSH NAGAR DELHI-110033NISHANT AGGARWALH.NO. D-42 HAKIKAT RAI ROAD NEAR LAXMI NARAYAN MANDHIR ADARSH NAGAR DELHI-110033All that Piece and Parcel of the Property bearing H.NO. D-42, LAND AREA MEASURING 120 SQ. YDS. SITUATED AT HAKIKAT RAI ROAD, ADARSH NAGAR, BEARING KHASRA NO.-262/258/270/4, VILLAGE BHAROLA, DELHI-110033All that Piece and Parcel of the Property bearing H.NO. D-39, GROUND FLOOR WITHOUT ROOF RIGHTS, AREA MEASURING 50 SQ. YDS., BLOCK-D, SITUATED AT RANA PRATAP ROAD, ADARSH NAGAR, BEARING KHASRA NO.-262/258/217/4, VILLAGE BHAROLA, DELHI-110033 - North : LANE 10 FT., South : REMAINING PORTION OF THE SAID PROPERTY, East : REMAINING PORTION OF THE SAID PROPERTY, West : PROPERTY NO. D-376574442Rupees Sixty Five Lakhs Seventy Four Thousand Four Hundred Forty Two Only4-Dec-20########348,353.9414,293.60172,157.0011,505.008005,124,183.20Rupees Fifty One Lakhs Twenty Four Thousand One Hundred Eighty Three and Paise Twenty Only8/17/2021
912319008Aug-2126-Aug-21250Link12069697-Feb-20PRADEEP AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033NISHANT AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033UNIQUE AGARSONS INDIASHOP NO. D-2357 NARELA INDUSTRIAL AREA DELHI-110040NEERAJ MITTALH. NO. - B-14 GALI NO. 6 SOUTH ANARKALI KRISHNA NAGAR DELHI-110051BHARAT AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033KIRAN AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033RAJEEVE AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SUNIL AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SANJEEV AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033SURDEEP AGGARWALH.NO. D-42 HAKIKAT RAI ROAD ADARSH NAGAR NEAR LAXMI NARAYAN MANDHIR DELHI-110033All that Piece and Parcel of the Property bearing H.NO. D-42, LAND AREA MEASURING 120 SQ. YDS. SITUATED AT HAKIKAT RAI ROAD, ADARSH NAGAR, BEARING KHASRA NO.-262/258/270/4, VILLAGE BHAROLA, DELHI-1100335638722Rupees Fifty Six Lakhs Thirty Eight Thousand Seven Hundred Twenty Two Only4-Dec-20########360,049.3215,046.99162,133.0016,815.001,400.005,218,157.14Rupees Fifty Two Lakhs Eighteen Thousand One Hundred Fifty Seven and Paise Fourteen Only8/17/2021

This is my Data, I need to compare two or three rows, if "Column-Unique No." is same for these rows. than i want to delete the duplicate data in rows which are same or similar and paste in new sheet as per Unique No. and also combine the data in one horizontal row for one Unique No.

Ex:
Sr.No.Total Link A/c. loanS&CO Case NoUnique IDLink A/c. Loan No. 1Link A/c. Loan No. 2Link A/c. Loan No. 3Link A/c. Loan No. 4Month of Cases13/2 Notice Date13/2 Notice Dispatched DateLink A/c./SingalMain BorrowerLink A/c. -1 Main Borrower Address 1Link A/c. -2 Main Borrower Address 2Link A/c. -3 Main Borrower Address 3Link A/c. -4 Main Borrower Address 4Co-Borrower 1Link A/c. -1 Co-Borrower 1 Address 1Link A/c. -2 Co-Borrower 1 Address 2Link A/c. -3 Co-Borrower 1 Address 3Link A/c. -4 Co-Borrower 1 Address 4Co-Borrower 2Link A/c. -1 Co-Borrower 2 Address 1Link A/c. -2 Co-Borrower 2 Address 2Link A/c. -3 Co-Borrower 2 Address 3Link A/c. -4 Co-Borrower 2 Address 4Co-Borrower 3Link A/c. -1 Co-Borrower 3 Address 1Link A/c. -2 Co-Borrower 3 Address 2Link A/c. -3 Co-Borrower 3 Address 3Link A/c. -4 Co-Borrower 3 Address 4Co-Borrower 4Link A/c. -1 Co-Borrower 4 Address 1Link A/c. -2 Co-Borrower 4 Address 2Link A/c. -3 Co-Borrower 4 Address 3Link A/c. -4 Co-Borrower 4 Address 4Co-Borrower 5Link A/c. -1 Co-Borrower 5 Address 1Link A/c. -2 Co-Borrower 5 Address 2Link A/c. -3 Co-Borrower 5 Address 3Link A/c. -4 Co-Borrower 5 Address 4Co-Borrower 6Link A/c. -1 Co-Borrower 6 Address 1Link A/c. -2 Co-Borrower 6 Address 2Link A/c. -3 Co-Borrower 6 Address 3Link A/c. -4 Co-Borrower 6 Address 4Co-Borrower 7Link A/c. -1 Co-Borrower 7 Address 1Link A/c. -2 Co-Borrower 7 Address 2Link A/c. -3 Co-Borrower 7 Address 3Link A/c. -4 Co-Borrower 7 Address 4Co-Borrower 8Link A/c. -1 Co-Borrower 8 Address 1Link A/c. -2 Co-Borrower 8 Address 2Link A/c. -3 Co-Borrower 8 Address 3Link A/c. -4 Co-Borrower 8 Address 4Co-Borrower 9Link A/c. -1 Co-Borrower 9 Address 1Link A/c. -2 Co-Borrower 9 Address 2Link A/c. -3 Co-Borrower 9 Address 3Link A/c. -4 Co-Borrower 9 Address 4Co-Borrower 10Link A/c. -1 Co-Borrower 10 Address 1Link A/c. -2 Co-Borrower 10 Address 2Link A/c. -3 Co-Borrower 10 Address 3Link A/c. -4 Co-Borrower 10 Address 4Link A/c. -1 Mortgage PropertyLink A/c. -2 Mortgage PropertyLink A/c. -3 Mortgage PropertyLink A/c. -4 Mortgage PropertyLink A/c. -1 Amount FinanceLink A/c. -1 Amount Finance in WORDSLink A/c. -1 Principal OutstandingLink A/c. -1 Pending Installment InterestLink A/c. -1 Interest till date of PrepaymentLink A/c. -1 Late Payment Penalty ChargesLink A/c. -1 Cheque Bouncing ChargesLink A/c. -1 Other ChargesLink A/c. -1 Prepayment Charges @ 4.72 %on Outstanding PrincipalLink A/c. -1 Refund, if anyLink A/c. -1 Total Amount OutstandingLink A/c. -1 Total Amount Outstanding in WORDSLink A/c. -1 FC DateLink A/c. -2 Amount FinanceLink A/c. -2 Amount Finance in WORDSLink A/c. -2 Principal OutstandingLink A/c. -2 Pending Installment InterestLink A/c. -2 Interest till date of PrepaymentLink A/c. -2 Late Payment Penalty ChargesLink A/c. -2 Cheque Bouncing ChargesLink A/c. -2 Other ChargesLink A/c. -2 Prepayment Charges @ 4.72 %on Outstanding PrincipalLink A/c. -2 Refund, if anyLink A/c. -2 Total Amount OutstandingLink A/c. -2 Total Amount Outstanding in WORDSLink A/c. -2 FC DateLink A/c. -3 Amount FinanceLink A/c. -3 Amount Finance in WORDSLink A/c. -3 Principal OutstandingLink A/c. -3 Pending Installment InterestLink A/c. -3 Interest till date of PrepaymentLink A/c. -3 Late Payment Penalty ChargesLink A/c. -3 Cheque Bouncing ChargesLink A/c. -3 Other ChargesLink A/c. -3 Prepayment Charges @ 4.72 %on Outstanding PrincipalLink A/c. -3 Refund, if anyLink A/c. -3 Total Amount OutstandingLink A/c. -3 Total Amount Outstanding in WORDSLink A/c. -3 FC DateLink A/c. -4 Amount FinanceLink A/c. -4 Amount Finance in WORDSLink A/c. -4 Principal OutstandingLink A/c. -4 Pending Installment InterestLink A/c. -4 Interest till date of PrepaymentLink A/c. -4 Late Payment Penalty ChargesLink A/c. -4 Cheque Bouncing ChargesLink A/c. -4 Other ChargesLink A/c. -4 Prepayment Charges @ 4.72 %on Outstanding PrincipalLink A/c. -4 Refund, if anyLink A/c. -4 Total Amount OutstandingLink A/c. -4 Total Amount Outstanding in WORDSLink A/c. -4 FC DateLink A/c. -1 NPA DateLink A/c. -2 NPA DateLink A/c. -3 NPA DateLink A/c. -4 NPA DateLink A/c. -1 LRN DateLink A/c. -2 LRN DateLink A/c. -3 LRN DateLink A/c. -4 LRN DateRegionAuthorised officerAuthorised officer's mail idAO Name
118190213245839949684MAHALAXMI PLASTICS AND ENGG WORKSPLOT NO 125 GROUND FLOOR POKET-I SECTOR 4 BAWANA DELHI-110039BASEMENT AND GROUND FLOOR I-55 SECTOR-2 DSIIDC BAWANA INDUSTRIAL AREA DELHI-110039 NEAR NAHAR DELHI-110039GEETA NARULAB 611 BLOCK B SUDARSHAN PARK NEW DELHI-110015BHOLA RAMB 611 BLOCK B SUDARSHAN PARK NEW DELHI-110015RAJESH NARULAB 611 BLOCK B SUDARSHAN PARK NEW DELHI-1100155,462,117.9318,836.7249,067.0011,483.0030,999.30257,811.975,830,315.92Rupees Fifty Eight Lakhs Thirty Thousand Three Hundred Fifteen and Paise Ninety Two Only8/17/2021

I shall be obliged if you can help
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,214,919
Messages
6,122,260
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top