Hi everyone,
I need to go from data in the format of
Field1 |
A |
B |
C |
D |
E |
to
Field1 | Field2 | Field3 | Field4 | Field5 |
A | B | C | D | E |
B | C | D | E | |
C | D | E | ||
D | E | |||
E |
I need the process to be flexible since fields with different lengths will be fed into my workflow.
Thanks!
Solved! Go to Solution.
This works perfectly. Thank you!
Hi Charlie,
After some more testing, I noticed that things break down when I have two of the same value consecutively in my starting column. Could you help me troubleshoot?
Field1 |
A |
B |
C |
C |
Transforms to
Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 |
A | B | C | C | C | C | C |
B | C | |||||
C |
EDIT:
I figured out a way to solve my issue. If you're curious, please see attached.
I'm happy to help. A Unique tool should take care of those duplicate values.