Null Fields and Group

[ManuelRodrigues]

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!

[dougperez]

Unchek the "Group by" 

[ManuelRodrigues]

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?

[dougperez · Accepted solution]

See this workflow

[ManuelRodrigues]

@dougperez  Thanks Bud!