Split Data in Duplicate Rows into Separate Columns

JoeHodgetts

Hello Community,

I'd like to split the data from duplicated weeks, e.g. weeks 26 and 34 in my example, into their own columns. I can achieve this with an ugly workflow and 5 tools, but it is not completely future proof (text to columns on a fixed number of columns), so I'm checking if there is a simpler way.

Thanks,

Joe

Split Scores (Com).yxmd

atcodedog05

Hi @JoeHodgetts 

Here is a dynamic workflow. It add columns as it increases.

Workflow:

Hope this helps : )

Split Scores (Com).yxmd