Alteryx Transform Output

[clarrock]

Hi Team, 

How do I make my data from this 

Date	Count
2020-09-11	68
2020-09-25	78

To Output as such - note that the dates will keep adding columns

Date	2020-09-11	2020-09-25
Count	68	78

And then make a basic table.. That is dynamic (with new date columns)

[echuong1]

This can be achieved using the cross-tab tool. If you continue adding dates, it will still work.

[clarrock]

@echuong1 thanks how do you keep the first column as row 1: date and row 2:count 

[echuong1 · Accepted solution]

Is this what you're looking for?