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

[atcodedog05 · Accepted solution]

Hi @JoeHodgetts 

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

Workflow:

Hope this helps : )

[binuacs]

@JoeHodgetts another option

[JoeHodgetts]

@atcodedog05 Spot on, works dynamically too. Thank you.

[atcodedog05]

Happy to help : ) @JoeHodgetts 

Cheers and have a nice day!