Hi everyone, I need to go from data in the format of Field1A BCDE to Field1Field2Field3Field4Field5ABCDEBCDE CDE DE E I need the process to be flexible since fields with different lengths will be fed into my workflow. Thanks!

Filling in a table with values from the first column

Hi everyone,

I need to go from data in the format of

Field1

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!

Tips and Tricks

Preparation

Accepted answers

CharlieS

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.

20180921-DecayingCrossTab.yxmd

All comments

CharlieS

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.

20180921-DecayingCrossTab.yxmd

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

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.

20180921-DecayingCrossTab.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703