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
