HI, I'm looking for a solution for this problem: after a Text To Columns tool I have a single field with multiple records, I'd like to create separate field after specific record encounterd, this record is the same every time.
Field_1
text
text
text
text
specific record
text1
text1
text1
text1
specific record
text2
text2
text2
specific record
Expected output:
New_Field_1 New_Field_2 New_Field_3
text text1 text2
text text1 text2
text text1 text2
text text1
Solved! Go to Solution.