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

- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Sep 17, 2019 at 07:18 AM
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

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571
0
Thank you
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!!!

Respond to ac3mark