Previous Topic Next Topic

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

Closed
LakshmiKanth - Sep 17, 2019 at 04:51 AM
 Blocked Profile - 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.

1 response

Answer 1 / 1
Blocked Profile
Updated on Sep 17, 2019 at 07:18 AM
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!!!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Name Values
brendanconlin -
TrowaD -

1 response