Hi Team, How do I make my data from this DateCount 2020-09-11682020-09-2578 To Output as such - note that the dates will keep adding columns Date2020-09-112020-09-25Count6878 And then make a basic table.. That is dynamic (with new date columns)

Alteryx Transform Output

Hi Team,

How do I make my data from this

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)

Workflow

Help

Is this what you're looking for?

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

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