Dear Sir,You're welcome. Thanks for the follow-up.
Looks like you were not aware of some of the new functions available in Microsoft 365.
If the data might change, meaning the names list in column D might grow or shrink, the column E formula might be better as shown below. You can copy this further down column E and then if new names are added in column A, those names and their grades will automatically appear in columns D, E, F, ...
Excel Formula:=IF(D2="","",TRANSPOSE(FILTER(B2:B8,A2:A8=D2)))
This is how my excel look like:
| Sr.No. | Total Link loan | Loan_No | Month of Cases | 13/2 Notice Date | 13/2 Notice Dispatched Date | DPD_13th July | Link_Singal | Unique ID | Region | Authorised officer | Authorised officer ‘s mail id | LRN Date | Customer_Name 1 | Customer_Add-1 | Co_app_1 Name | Co_app_1 Address | Co_app_2 Name | Co_app_2 Address | Co_app_3 Name | Co_app_3 Address | Co_app_4 Name | Co_app_4 Address | Co_app_5 Name | Co_app_5 Address | Co_app_6 Name | Co_app_6 Address | Co_app_7 Name | Co_app_7 Address | Co_app_8 Name | Co_app_8 Address | Co_app_9 Name | Co_app_9 Address | Gar_1 Name | Gar_1 Address | Gar_3 Name | Gar_3 Address | property address_1 | property address_2 | property address_3 | Amount Finance | Amount Finance in word | NPA date | Loan_No | Principal Outstanding | Pending Installment Interest | Interest till date of Prepayment | Late Payment Penalty Charges | Cheque Bouncing Charges | Other Charges | Prepayment Charges @ 4.72 %on Outstanding Principal | Refund, If Any | Total Amount Payable | Total Amount Payable in words | FC Date | Schedule of the Property-1 | Boundaries North_1 | Boundaries South_1 | Boundaries East_1 | Boundaries West_1 | Schedule of the Property-2 | Boundaries North_2 | Boundaries South_2 | Boundaries East_2 | Boundaries West_2 | Schedule of the Property-3 | Boundaries North_3 | Boundaries South_3 | Boundaries East_3 | Boundaries West_3 | Schedule of the Property-4 | Boundaries North_4 | Boundaries South_4 | Boundaries East_4 | Boundaries West_4 |
| 16 | 1 | 6431728 | Aug-21 | 26-Aug-21 | 99 | Link | 9353504 | North | Vikas Anand | vikas.anand@hdbfs.com | NA | STYLISH GARMENTS | 6310 MAIN ROAD GANDHI NAGAR DELHI-110031 | SACHIN KOCHER | H NO-K-1 NEW GOVIND PURA EXT. CHANDER NAGAR DELHI DELHI-110031 | KANCHAN KOCHER | H NO-K-1 NEW GOVIND PURA EXT. CHANDER NAGAR DELHI DELHI-110051 | All that Piece and Parcel of the Property bearing No.-K-1, AREA MEASURING 40 SQ. YDS., OUT OF KHASRA NO-11/23, VILLAGE KHUREJI KHAS, NEW GOBIND PURA EXTN., NR MATA MANDIR, SHAHDARA, DELHI-110051 AND BOUNDED AS EAST -PROPERTY OF OTHERS;, WEST - PORTION OF SAID PROPERTY NO.K-1; NORTH-GALI 20 FT. WIDE; SOUTH -PROPERTY OF OTHERS | 3400000 | Rupees Thirty Four Lakhs Only | 3-Jun-21 | 6431728 | ######## | 93,140.99 | 7,465.47 | 55,530.00 | 10,620.00 | 600 | 102,176.06 | ######## | Rupees Twenty Seven Lakhs Nine Thousand One Hundred Ninety Two and Paise Fifty Two Only | 8/17/2021 | ||||||||||||||||||||||||||||||||||||||||||
| 17 | 3 | 12828878 | Aug-21 | 26-Aug-21 | 8 | Link | 9355051 | North | Vikas Anand | vikas.anand@hdbfs.com | NA | MS A D FOOTWEAR | 8/220 MALVIYA NAGAR JAIPUR JAIPUR-302017 | RAJNI CHANDAVANI | 8/220 MALVIYA NAGAR JAIPUR JAIPUR-302017 | INDRA KUMAR CHANDWANI | 8/220 MALVIYA NAGAR JAIPUR JAIPUR-302017 | All the piece and parcel of the P. No. 8/220, SECTOR 8, AMIT BHARDWAJ MARG, MALVIYA NAGAR, JAIPUR, RAJASTHAN. Land /Plot Area 67.50 sqm or 726.30 sqft North . No. 8/221 South. No. 8/219 East:-Road 30’ Wide West. No. 8/233 | All the piece and parcel of the -SHOP SITUATED AT HAWELI 2 CHOWK KI, OPP. NARSINGH TEMPLE, JAAT KE KUYE KA RASTA(WEST LINE) CHOWKDI, PURANI BASTI, CHANDPOLE, JAIPUR, RAJASTHAN. Built up Area 113.11 sqft North:-Shop of Mr. RAM Gopal South:-House of Mr. Roshan lal Pitaliya East:-Jaat Ke Ku | All the piece and parcel of the -P. No. 8/52, SECTOR 8, AMIT BHARDWAJ MARG, MALVIYA NAGAR, JAIPUR, RAJASTHAN. Area of Land /Plot 473.44 SQ. FT. & 52.60 SQ. YDS.North. No. 8/45 South:-Road 30’ Wide East. No. 8/52 West. No. 8/51 | 760000 | Rupees Seven Lakhs Sixty Thousand Only | 12828878 | 760,000.00 | 7,282.00 | 3,155.53 | 1,188.00 | 4,425.00 | 35,872.00 | 811,922.53 | Rupees Eight Lakhs Eleven Thousand Nine Hundred Twenty Two and Paise Fifty Three Only | 8/17/2021 | ||||||||||||||||||||||||||||||||||||||||||
| 18 | 2 | 4161001 | Aug-21 | 26-Aug-21 | 158 | Link | 9355051 | North | Vikas Anand | vikas.anand@hdbfs.com | 21-Jul-20 | A D FOOTWEAR | 8/220 MALVIYA NAGAR JAIPUR-302017 | RAJNI CHANDWANI | 8/220 MALVIYA NAGAR JAIPUR-302017 | INDRA KUMAR CHANDWANI | 8/220 MALVIYA NAGAR JAIPUR-302017 | All the piece and parcel of the P. No. 8/220, SECTOR 8, AMIT BHARDWAJ MARG, MALVIYA NAGAR, JAIPUR, RAJASTHAN. Land /Plot Area 67.50 sqm or 726.30 sqft North. No. 8/221 South. No. 8/219 East:-Road 30’ Wide West. No. 8/233 | All the piece and parcel of the -SHOP SITUATED AT HAWELI 2 CHOWK KI, OPP. NARSINGH TEMPLE, JAAT KE KUYE KA RASTA(WEST LINE) CHOWKDI, PURANI BASTI, CHANDPOLE, JAIPUR, RAJASTHAN. Built up Area 113.11 sqft North:-Shop of Mr. RAM Gopal South:-House of Mr. Roshan lal Pitaliya East:-Jaat Ke Ku | 499138 | Rupees Four Lakhs Ninety Nine Thousand One Hundred Thirty Eight Only | 5-Apr-21 | 4161001 | 302,219.00 | 14,706.67 | 812.07 | 13,880.00 | 16,639.00 | 400 | 11,475.26 | 360,132.00 | Rupees Three Lakhs Sixty Thousand One Hundred Thirty Two Only | 8/17/2021 | |||||||||||||||||||||||||||||||||||||||||
| 19 | 1 | 4249675 | Aug-21 | 26-Aug-21 | 130 | Link | 9355051 | North | Vikas Anand | vikas.anand@hdbfs.com | NA | A D FOOTWEAR | 08/220 MALVIYA NAGAR JAIPUR-302017 | INDRA KUMAR CHANDWANI | 8/220 MALVIYA NAGAR JAIPUR-302017 | RAJNI CHANDWANI | 8/220 MALVIYA NAGAR JAIPUR-302017 | All the piece and parcel of the P. No. 8/220, SECTOR 8, AMIT BHARDWAJ MARG, MALVIYA NAGAR, JAIPUR, RAJASTHAN. Land /Plot Area 67.50 sqm or 726.30 sqft North. No. 8/221 South. No. 8/219 East:-Road 30’ Wide West. No. 8/233 | All the piece and parcel of the -SHOP SITUATED AT HAWELI 2 CHOWK KI, OPP. NARSINGH TEMPLE, JAAT KE KUYE KA RASTA(WEST LINE) CHOWKDI, PURANI BASTI, CHANDPOLE, JAIPUR, RAJASTHAN. Built up Area 113.11 sqft North:-Shop of Mr. RAM Gopal South:-House of Mr. Roshan lal Pitaliya East:-Jaat Ke Ku | 4800000 | Rupees Forty Eight Lakhs Only | 3-Jun-21 | 4249675 | ######## | 109,475.00 | 8,624.63 | 70,278.96 | 12,390.00 | 600 | 121,869.17 | ######## | Rupees Thirty Three Lakhs Nine Thousand Four Hundred Thirty and Paise Seventy Six Only | 8/17/2021 | |||||||||||||||||||||||||||||||||||||||||
| 20 | 2 | 4853648 | Aug-21 | 26-Aug-21 | 130 | Link | 9355081 | North | Vikas Anand | vikas.anand@hdbfs.com | NA | R KUMAR BUS SERVICE | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 | SOHAN LAL | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 | RAJ KUMAR | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 | BRIJESHWARI HARLAL | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 | RAVI KUMAR | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 | All that Piece and Parcel of the Built up Property bearing No. RZF-371, PLOT NO.-36, LAND ADMEASURING 100 SQ. YDS., LOHIA MARG, RAJ NAGAR-2, PALAM COLONY, PALAM, DELHI-110077 | 10000000 | Rupees One Crore Only | 3-Jun-21 | 4853648 | ######## | 406,591.00 | 28,042.73 | 114,995.00 | 9,735.00 | 200 | 375,938.47 | ######## | Rupees Ninety Four Lakhs Twenty One Thousand Three Hundred Thirty Eight and Paise Twenty Only | 8/17/2021 | ||||||||||||||||||||||||||||||||||||||
| 21 | 1 | 12861813 | Aug-21 | 26-Aug-21 | 130 | Link | 9355081 | North | Vikas Anand | vikas.anand@hdbfs.com | NA | R KUMAR BUS SERVICE | RZ F-371 KHASRA NO 15/12 BLOCK F LOHIYA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 DELHI | BRIJESHWARI HARLAL | RZF-371 KHASRA NO-15/12 BLOCK-F LOHIA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 DELHI | RAVI KUMAR | RZF-371 KHASRA NO-15/12 BLOCK-F LOHIA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110017 DELHI | SOHAN LAL | RZF-371 KHASRA NO-15/12 BLOCK-F LOHIA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 DELHI | RAJ KUMAR | RZF-371 KHASRA NO-15/12 BLOCK-F LOHIA MARG RAJ NAGAR-2 PALAM COLONY DELHI-110071 DELHI | All that Piece and Parcel of the Property bearing No. RZF-371/A(OLD NO.37/1), ON LAND MEASURING 50 SQ. YDS., FORMING PART OF KHASRA NO.51/12/2, 16,18,19/4,25, LOHIA MARG, RAJ NAGAR-2, PALAM COLONY, PALAM, DELHI-110077 AND BOUNDED AS EAST- PROPERTY ON PLOT NO.37/2; WEST-PROPERTY ON PLOT NO.38; NORTH-ROAD; SOUTH-ROAD | 1745000 | Rupees Seventeen Lakhs Forty Five Thousand Only | 3-Jun-21 | 12861813 | ######## | 95,673.00 | 6,931.17 | 9,377.00 | 7,965.00 | 82,364.00 | ######## | Rupees Nineteen Lakhs Forty Seven Thousand Three Hundred Ten and Paise Seventeen Only | 8/17/2021 | |||||||||||||||||||||||||||||||||||||||
| 22 | 2 | 12860171 | Aug-21 | 26-Aug-21 | 69 | Link | 9363095 | North | Vikas Anand | vikas.anand@hdbfs.com | 23-Apr-21 | MS SHREE LADIES WEAR | 71 SOMNATH MANDIR KE PICHE PALI PALI PALI HO-306401 | BABU LAL | 69 KESHAV NAGAR MAIN SERVICE CENTER KE PASS WALI GALI PALI PALI HO-306401 | SUMITRA SHARMA | 69 KESHAV NAGAR MANU SERVICE CENTER KE PASS WALI GALI PALI PALI HO-306401 | VIRENDRA KUMAR | NEW BUS STAND KESHAV NAGAR PALI PALI PALI HO-306401 | PLOT MO. 69, KHASRA NO.1299 MADHAV NAGAR EAST ROAD, WEST PLOT NO. 82 NORTH PLOT NO. 68 SOUTH PLOT NO. 70 PALI HO-306401 | 399000 | Rupees Three Lakhs Ninety Nine Thousand Only | 12860171 | 397,492.00 | 17,015.00 | 1,937.87 | 1,617.00 | 7,965.00 | 200 | 18,761.62 | 444,988.49 | Rupees Four Lakhs Forty Four Thousand Nine Hundred Eighty Eight and Paise Forty Nine Only | 8/17/2021 | |||||||||||||||||||||||||||||||||||||||||
| 23 | 1 | 6005099 | Aug-21 | 26-Aug-21 | 158 | Link | 9363095 | North | Vikas Anand | vikas.anand@hdbfs.com | 23-Apr-21 | MS SHREE LADIES WEAR | SOMNATH MANDIR KE PICHE PALI HO-306401 | BABU LAL | 69 KESHAV NAGAR PALI HO-306401 | VIRENDRA KUMAR | 69 KESHAV NAGAR PALI HO-306401 | SUMITRA SHARMA | 69 KESHAV NAGAR PALI HO-306401 | ALL THAT PIECE AND PARCEL OF PLOT NO 69 HAVING AREA ADMEASURING 133.33 SQ. YDS., KHASRA NO. 1299, MADHAV NAGAR PALI PALI HO-306401 | 2200000 | Rupees Twenty Two Lakhs Only | 6-May-21 | 6005099 | ######## | 145,260.00 | 8,804.03 | 32,760.00 | 13,275.00 | 1,257.89 | 101,836.36 | ######## | Rupees Twenty Five Lakhs Five Thousand Two Hundred Four and Paise Twenty Eight Only | 8/17/2021 | ||||||||||||||||||||||||||||||||||||||||
On the basis of Unique ID i want to combine data in one row. So the Excel looks like the following table format:
| Sr.No. | Total Link A/c. loan | Unique ID | Link A/c. Loan No. 1 | Link A/c. Loan No. 2 | Link A/c. Loan No. 3 | Link A/c. Loan No. 4 | Month of Cases | 13/2 Notice Date | 13/2 Notice Dispatched Date | Link A/c./Singal | Main Borrower | Link A/c. -1 Main Borrower Address 1 | Link A/c. -2 Main Borrower Address 2 | Link A/c. -3 Main Borrower Address 3 | Link A/c. -4 Main Borrower Address 4 | Co-Borrower 1 | Link A/c. -1 Co-Borrower 1 Address 1 | Link A/c. -2 Co-Borrower 1 Address 2 | Link A/c. -3 Co-Borrower 1 Address 3 | Link A/c. -4 Co-Borrower 1 Address 4 | Co-Borrower 2 | Link A/c. -1 Co-Borrower 2 Address 1 | Link A/c. -2 Co-Borrower 2 Address 2 | Link A/c. -3 Co-Borrower 2 Address 3 | Link A/c. -4 Co-Borrower 2 Address 4 | Co-Borrower 3 | Link A/c. -1 Co-Borrower 3 Address 1 | Link A/c. -2 Co-Borrower 3 Address 2 | Link A/c. -3 Co-Borrower 3 Address 3 | Link A/c. -4 Co-Borrower 3 Address 4 | Co-Borrower 4 | Link A/c. -1 Co-Borrower 4 Address 1 | Link A/c. -2 Co-Borrower 4 Address 2 | Link A/c. -3 Co-Borrower 4 Address 3 | Link A/c. -4 Co-Borrower 4 Address 4 | Co-Borrower 5 | Link A/c. -1 Co-Borrower 5 Address 1 | Link A/c. -2 Co-Borrower 5 Address 2 | Link A/c. -3 Co-Borrower 5 Address 3 | Link A/c. -4 Co-Borrower 5 Address 4 | Co-Borrower 6 | Link A/c. -1 Co-Borrower 6 Address 1 | Link A/c. -2 Co-Borrower 6 Address 2 | Link A/c. -3 Co-Borrower 6 Address 3 | Link A/c. -4 Co-Borrower 6 Address 4 | Co-Borrower 7 | Link A/c. -1 Co-Borrower 7 Address 1 | Link A/c. -2 Co-Borrower 7 Address 2 | Link A/c. -3 Co-Borrower 7 Address 3 | Link A/c. -4 Co-Borrower 7 Address 4 | Co-Borrower 8 | Link A/c. -1 Co-Borrower 8 Address 1 | Link A/c. -2 Co-Borrower 8 Address 2 | Link A/c. -3 Co-Borrower 8 Address 3 | Link A/c. -4 Co-Borrower 8 Address 4 | Co-Borrower 9 | Link A/c. -1 Co-Borrower 9 Address 1 | Link A/c. -2 Co-Borrower 9 Address 2 | Link A/c. -3 Co-Borrower 9 Address 3 | Link A/c. -4 Co-Borrower 9 Address 4 | Co-Borrower 10 | Link A/c. -1 Co-Borrower 10 Address 1 | Link A/c. -2 Co-Borrower 10 Address 2 | Link A/c. -3 Co-Borrower 10 Address 3 | Link A/c. -4 Co-Borrower 10 Address 4 | Link A/c. -1 Mortgage Property | Link A/c. -2 Mortgage Property | Link A/c. -3 Mortgage Property | Link A/c. -4 Mortgage Property | Link A/c. -1 Amount Finance | Link A/c. -1 Amount Finance in WORDS | Link A/c. -1 Principal Outstanding | Link A/c. -1 Pending Installment Interest | Link A/c. -1 Interest till date of Prepayment | Link A/c. -1 Late Payment Penalty Charges | Link A/c. -1 Cheque Bouncing Charges | Link A/c. -1 Other Charges | Link A/c. -1 Prepayment Charges @ 4.72 %on Outstanding Principal | Link A/c. -1 Refund, if any | Link A/c. -1 Total Amount Outstanding | Link A/c. -1 Total Amount Outstanding in WORDS | Link A/c. -1 FC Date | Link A/c. -2 Amount Finance | Link A/c. -2 Amount Finance in WORDS | Link A/c. -2 Principal Outstanding | Link A/c. -2 Pending Installment Interest | Link A/c. -2 Interest till date of Prepayment | Link A/c. -2 Late Payment Penalty Charges | Link A/c. -2 Cheque Bouncing Charges | Link A/c. -2 Other Charges | Link A/c. -2 Prepayment Charges @ 4.72 %on Outstanding Principal | Link A/c. -2 Refund, if any | Link A/c. -2 Total Amount Outstanding | Link A/c. -2 Total Amount Outstanding in WORDS | Link A/c. -2 FC Date | Link A/c. -3 Amount Finance | Link A/c. -3 Amount Finance in WORDS | Link A/c. -3 Principal Outstanding | Link A/c. -3 Pending Installment Interest | Link A/c. -3 Interest till date of Prepayment | Link A/c. -3 Late Payment Penalty Charges | Link A/c. -3 Cheque Bouncing Charges | Link A/c. -3 Other Charges | Link A/c. -3 Prepayment Charges @ 4.72 %on Outstanding Principal | Link A/c. -3 Refund, if any | Link A/c. -3 Total Amount Outstanding | Link A/c. -3 Total Amount Outstanding in WORDS | Link A/c. -3 FC Date | Link A/c. -4 Amount Finance | Link A/c. -4 Amount Finance in WORDS | Link A/c. -4 Principal Outstanding | Link A/c. -4 Pending Installment Interest | Link A/c. -4 Interest till date of Prepayment | Link A/c. -4 Late Payment Penalty Charges | Link A/c. -4 Cheque Bouncing Charges | Link A/c. -4 Other Charges | Link A/c. -4 Prepayment Charges @ 4.72 %on Outstanding Principal | Link A/c. -4 Refund, if any | Link A/c. -4 Total Amount Outstanding | Link A/c. -4 Total Amount Outstanding in WORDS | Link A/c. -4 FC Date | Link A/c. -1 NPA Date | Link A/c. -2 NPA Date | Link A/c. -3 NPA Date | Link A/c. -4 NPA Date | Link A/c. -1 LRN Date | Link A/c. -2 LRN Date | Link A/c. -3 LRN Date | Link A/c. -4 LRN Date | Region | Authorised officer | Authorised officer's mail id | AO Name |
Please help me how to do this in a very simple way.
Thanks
