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

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.