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

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,011
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top