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.

number	Desc
12445	This file discusses about reasons 1. Reason1 2. Reason2 3. Reason3 4. Reason4 5. Reason5
13445	This file discusses about reason for all details. 1. Reason1 2. Reason2 3. Reason3 4. Reason4 5. Reason5
14555	This file discusses about reason for all details. 1. Reason1 2. Reason2 3. Reason3 4. Reason4 5. Reason5

<tbody>
</tbody>

Please find data after segregating.

number	Desc	reason1	reason2	reason3	reason4	reason5
12445	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
13445	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
14555	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
15666	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
16777	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.

<tbody>
</tbody>

Thanks and regards,
R Sairaj

 

[sai_rajr]

Please ignore above. Please find data before segregating.

number	Desc
12445	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.
13445	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.
14555	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.

<tbody>
</tbody>

Please find data after segregating.

number	Desc	reason1	reason2	reason3	reason4	reason5
12445	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
13445	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
14555	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
15666	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.
16777	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.	due to external factors.	due to input issues.	due to user understanding.	due to network issue.	due to third party issue.

<tbody>
</tbody>

Thanks and regards,
R Sairaj