deven_deesha
Board Regular
- Joined
- Jan 5, 2006
- Messages
- 134
I have a row as follow .
COL B has a data seperated by Alt + Enter. There is a duplciate data.
If there is a duplicate data then i want to neglect it and consider only one.
ex. Consider the following example
SUIT/ADR is may times in COL B. This is a input File.
COL A COL B
1 Suit/ADR
Suit/ADR
Suit/ADR
Suit/ADR
Claim Folder
2 Claim Folder
Claim Mgmt
I want the output in new file as
1 SUIT/ADR
1 Claim Folder
2 Claim Folder
2 Claim Mgmt
I tried to write a macro using Split function. But I stucked. Can you please help me?
Thanks
Shriswaroop
COL B has a data seperated by Alt + Enter. There is a duplciate data.
If there is a duplicate data then i want to neglect it and consider only one.
ex. Consider the following example
SUIT/ADR is may times in COL B. This is a input File.
COL A COL B
1 Suit/ADR
Suit/ADR
Suit/ADR
Suit/ADR
Claim Folder
2 Claim Folder
Claim Mgmt
I want the output in new file as
1 SUIT/ADR
1 Claim Folder
2 Claim Folder
2 Claim Mgmt
I tried to write a macro using Split function. But I stucked. Can you please help me?
Thanks
Shriswaroop