Filling in a table with values from the first column

[aarhintz]

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!

[CharlieS · Accepted solution]

There's probably a cleaner way to do this, but the attached solution will get the job done. Let me know if this works for you.

 

[aarhintz]

This works perfectly.  Thank you!

[aarhintz]

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.

[CharlieS]

I'm happy to help. A Unique tool should take care of those duplicate values.