SOLVED:Need Help to Get Data by Individual Dates from Calendar Matrix in Excel Spreadsheet

[taxtechfl]

I am looking for assistance to convert a set of data in a spreadsheet that is arranged in columns going across by month and day in a calendar format.  The month is a row above the day of the month.

I have tried a couple of different approaches, but there is likely a much easier way with fewer steps.  If anyone can help with this, I would be greatly appreciate it.  Thank you.

Below is a screen shot of how the data set is arranged.  

The desired result is to have the values for each record corresponding to each date.  A sample of the results for Entity1 would be something like the following:

Entity	Date	Value
Entity1	2020-01-01
Entity1	2020-01-02	1
Entity1	2020-01-03	1
Entity1	2020-01-04	1
Entity1	2020-01-05	1
Entity1	2020-01-06
Entity1	2020-01-07
Entity1	2020-01-08	1
Entity1	2020-01-09	1
Entity1	2020-01-10	1
Entity1	2020-01-11
Entity1	2020-01-12
Entity1	2020-01-13
Entity1	2020-01-14
Entity1	2020-01-15
Entity1	2020-01-16
Entity1	2020-01-17
Entity1	2020-01-18
Entity1	2020-01-19
Entity1	2020-01-20
Entity1	2020-01-21
Entity1	2020-01-22
Entity1	2020-01-23
Entity1	2020-01-24
Entity1	2020-01-25
Entity1	2020-01-26
Entity1	2020-01-27
Entity1	2020-01-28
Entity1	2020-01-29
Entity1	2020-01-30
Entity1	2020-01-31
Entity1	2020-02-01
Entity1	2020-02-02
Entity1	2020-02-03
Entity1	2020-02-04
Entity1	2020-02-05
Entity1	2020-02-06
Entity1	2020-02-07	1
Entity1	2020-02-08	1
Entity1	2020-02-09	1
Entity1	2020-02-10

[fmvizcaino]

Hi @taxtechfl ,

This is the best I could build. Merge columns is not possible in Alteryx without using a complex workflow and reporting tools.

Best,

Fernando Vizcaino

[taxtechfl]

Thank you, Fernando (@fmvizcaino) , for developing the workflow for me.  That can come in handy for me to work in both directions with this data.  Unfortunately the original data is the one that is arranged going across by month and day in the horizontal calendar format, meaning the rows of dates and values by entity is the end result desired rather than the starting point (input data).  I apologize for the misunderstanding.  I hope this helps clarify.

[fmvizcaino · Accepted solution]

Sorry @taxtechfl , my bad! 

Here it is.

Best,

Fernando Vizcaino

[taxtechfl]

@fmvizcaino Fernando:

Thank you for the solution, and thank you so much for doing this so quickly!  I really appreciate it!