Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Need to extract the data from one page to another page based on the unique numbe

Report
-
 Blocked Profile -
Hi
i have data like below mentioned format, need to extract and paste it in another sheet, please help me in it.

DEAL_NO DEAL_DATE APPLICATION_OFFICER LOAN_TYPE LOAN_AMOUNT TENURE CUSTOMER_NAME CUSTOMER_ID ADDRESS_TYPE CATEGORY ADDRESS
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTHOD RAVI 500 RESIDENCE APPLICANT ROAD NO 14,8-2-293/206/29,BANJARAHILLS,SRI VENKATE
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTHOD RAVI 500 OFFICE APPLICANT NIZAMPET KKP,KUKATPALLY,1ST FLOOR,H NO 1-2-317, HY
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI BIKSHAM 501 RESIDENCE COAPPLICANT H NO 8-2-293/65/38/1,,KHAIRTABAD,ROAD NO 14,SRI VE
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI BIKSHAM 501 OFFICE COAPPLICANT TELANAGN STSTE SECERATIRAT,TS STREET,REVENUVE DAPA
DXHOF01319-200003450 07/08/2019 B VENKAT RAMANA IA03 1000000.0000 84 KARAMTOTI YADAMMA 528 RESIDENCE COAPPLICANT H NO 8-2-293/65/38/1,,KHAIRTABAD,ROAD NO 14,SRI VE

need to make it in single line in another excel.
See more

1 reply

Answer 1 / 1

You need to be careful posting possible sensitive customer information on the web! I hope this is not actual customer data. You may be in violation of certain laws!!!

Reply Ask a question