Hi Team My data is in this Format: I have the first part of the workflow to cross tab it into columns (see workflow). The end result i am looking to get to (e.g. duration) is: 6121824303642485460DurationDurationDurationDurationDurationDurationDurationDurationDurationDuration This format needs to be replicated for all the data in this data set however i am struggling to see ho i can get this done? thanks in adv! New Workflow7.yxmd

Null Fields and Group

Hi Team

My data is in this Format:

I have the first part of the workflow to cross tab it into columns (see workflow). The end result i am looking to get to (e.g. duration) is:

6	12	18	24	30	36	42	48	54	60
Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration

This format needs to be replicated for all the data in this data set however i am struggling to see ho i can get this done?

thanks in adv!

See this workflow

Unchek the "Group by"

Thanks @dougperez - how do i then re-arrange all the common fields like Duration such that it shows:

6	12	18	24	30	36	42	48	54	60
Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration	Duration

and like wise for the other values in the data set?

See this workflow

@dougperez Thanks Bud!