Converting a column of dates into column headers

[Scythe80]

hello everyone,

I have a dataset where I have 5 columns and just over 1000 rows. One of the columns is a date column, with dates being the first day of each month. Every month is represented in the dataset. I want modify my data so that there are January, February, March, etc headers, and that the remaining data in the other 4 columns (that is not date) is properly assigned based on the date in the original dataset. 

Is this something alteryx can accomplish?

[kelsey_kincaid · Accepted solution]

Hi @Scythe80 ,

I would suggest taking a look at the Crosstab tool. This tool allows you to convert rows to columns in a variety of ways. Let me know if you need any help with configuration.

[Scythe80]

Hey @kelsey_kincaid

figured it out! New to alteryx and hadn't used cross-tab. thank you for pointing me in the right direction!