Create new field names based on details in description in excel file

[sai_rajr]

Hi Sir,

This is Sairaj. Have an excel file with number and desc. Please help to segegate reasons into new fields.
https://www.4shared.com/account/home.jsp#dir=4cvJIQVb

File.xls sheet1 contains before segregating fields.

File.xls sheet2 contains after segregating fields.


Thanks and regards,
R Sairaj

 

[sai_rajr]

Please advise.


Thanks and regards,
R Sairaj[/QUOTE]

 

[sai_rajr]

Hi Sir,

This is Sairaj. Have an excel file with number and desc. Please help to segegate reasons into new fields.
https://www.4shared.com/account/home.jsp#dir=4cvJIQVb

File.xls sheet1 contains before segregating fields.

File.xls sheet2 contains after segregating fields.


Thanks and regards,
R Sairaj

 

[Fluff]

You will have a better chance of getting some help if you clearly explain what you are after & show both before & after examples of your data.
A lot of members will not download files due to corporate policy & or security reasons (also your link is asking for login details).
There are some tools available here to enable you to post data to the board

 

[sai_rajr]

sure. Please find raw data before segregating.

[TABLE="width: 311"]
<tbody>[TR]
[TD]number
[/TD]
[TD]Desc
[/TD]
[/TR]
[TR]
[TD]12445
[/TD]
[TD]This file discusses about reasons





1. Reason1
2. Reason2
3. Reason3
4. Reason4
5. Reason5
[/TD]
[/TR]
[TR]
[TD]13445
[/TD]
[TD]This file discusses about reason for all details.


1. Reason1
2. Reason2
3. Reason3
4. Reason4
5. Reason5
[/TD]
[/TR]
[TR]
[TD]14555
[/TD]
[TD]This file discusses about reason for all details.


1. Reason1
2. Reason2
3. Reason3
4. Reason4
5. Reason5
[/TD]
[/TR]
</tbody>[/TABLE]


Please find data after segregating.


[TABLE="width: 1129"]
<tbody>[TR]
[TD]number
[/TD]
[TD]Desc
[/TD]
[TD]reason1
[/TD]
[TD]reason2
[/TD]
[TD]reason3
[/TD]
[TD]reason4
[/TD]
[TD]reason5
[/TD]
[/TR]
[TR]
[TD]12445
[/TD]
[TD]This file discusses about reasons





1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]13445
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]14555
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]15666
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]16777
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks and regards,
R Sairaj

 

[sai_rajr]

Please ignore above. Please find data before segregating.

[TABLE="width: 311"]
<tbody>[TR]
[TD]number
[/TD]
[TD]Desc
[/TD]
[/TR]
[TR]
[TD]12445
[/TD]
[TD]This file discusses about reasons





1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[/TR]
[TR]
[TD]13445
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[/TR]
[TR]
[TD]14555
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[/TR]
</tbody>[/TABLE]


Please find data after segregating.

[TABLE="width: 1129"]
<tbody>[TR]
[TD]number
[/TD]
[TD]Desc
[/TD]
[TD]reason1
[/TD]
[TD]reason2
[/TD]
[TD]reason3
[/TD]
[TD]reason4
[/TD]
[TD]reason5
[/TD]
[/TR]
[TR]
[TD]12445
[/TD]
[TD]This file discusses about reasons





1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]13445
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]14555
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]15666
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
[TR]
[TD]16777
[/TD]
[TD]This file discusses about reason for all details.



1. Reason1: due to external factors.
2. Reason2: due to input issues.
3. Reason3: due to user understanding.
4. Reason4: due to network issue.
5. Reason5: due to third party issue.
[/TD]
[TD]due to external factors.
[/TD]
[TD]due to input issues.
[/TD]
[TD]due to user understanding.
[/TD]
[TD]due to network issue.
[/TD]
[TD]due to third party issue.
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks and regards,
R Sairaj