Transposing a Unique Value per Group By

[cmyer]

Hi Alteryx Users, 

I currently have a data set the looks like this:

Name        Status      Time      Location 

Data 1          Y               12            45

Data 1          Y               12            45

Data 1          Y               12            45

Data 2          Y               14            60

Data 2          Y               14            60

Data 3          Y               14            60

I would like to transpose the first unique value of each group leaving blank spaces in between (not NULLs):

Name        Status      Time      Location    Time Ext     Location Ext 

Data 1          Y               12            45               12                    45

Data 1          Y               12            45

Data 1          Y               12            45

Data 2          Y               14            60               14                    60

Data 2          Y               14            60

Data 3          Y               14            60

Any Ideas on how I can achieve this?

[Jonathan-Sherman]

Hi @cmyer,

The only way to store the empty cells in Time Ext and Location Ext as empty rather than Null would be to store the fields as a string.

Kind regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

But you could attach just to the first one by identifying the record and joining to only that record, subsequently unioning all the data back together!

Kind regards,

Jonathan

[cmyer]

Hi Jonathon 

Assuming I left NULLS how can I achieve the transpose? 

[cmyer]

THANKS 🙂

[Jonathan-Sherman]

No problem! 😀