?crosstabs

[vivian123]

Hi All, 

How do I take the earliest week with a data entry from table 1 to make table 2? 

Customer ID	Week 1	Week 2	Week 3
1		47
2			48
3		52

Customer ID	Earliest Week
1	2
2	3
3	2

Thanks!

[Kenda]

Hi @vivian123 

In this case, I think it would help to first transpose your data, using the Customer ID field as a key column. From here (assuming the earliest week means the first one populated from your data), you can use a Filter tool to get rid of the empty values then use a Sample tool to only keep the first record for each Customer ID. Lastly, you can use a Formula tool to create a field that will display what week # that value came from. 

Hope this helps!

[apathetichell]

I remember the first time I saw "no samples, keyboards or synthesizers used in the making of this record" and I was like "Wow that's so cool!" and of course then I realized that synthesizers, keyboards and samples are awesome.

Anyway - if you were ever scarred by the sample tool and wanted a version without one - see the attached workflow which is (along with being horizontal) about the same as @Kenda 's awesome workflow in terms of use-value.

[Junya_Wang]

this is the simplest solution I can think of