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: EntityDateValueEntity12020-01-01 Entity12020-01-021Entity12020-01-031Entity12020-01-041Entity12020-01-051Entity12020-01-06 Entity12020-01-07 Entity12020-01-081Entity12020-01-091Entity12020-01-101Entity12020-01-11 Entity12020-01-12 Entity12020-01-13 Entity12020-01-14 Entity12020-01-15 Entity12020-01-16 Entity12020-01-17 Entity12020-01-18 Entity12020-01-19 Entity12020-01-20 Entity12020-01-21 Entity12020-01-22 Entity12020-01-23 Entity12020-01-24 Entity12020-01-25 Entity12020-01-26 Entity12020-01-27 Entity12020-01-28 Entity12020-01-29 Entity12020-01-30 Entity12020-01-31 Entity12020-02-01 Entity12020-02-02 Entity12020-02-03 Entity12020-02-04 Entity12020-02-05 Entity12020-02-06 Entity12020-02-071Entity12020-02-081Entity12020-02-091Entity12020-02-10 Calendar Tracker - Copy.xlsx

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

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.

Calendar Matrix Screen Shot.png

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

Calendar Tracker - Copy.xlsx

Developer

Developer Tools

Date Time

Transformation

Time Series

Accepted answers

fmvizcaino

Sorry @taxtechfl , my bad!

Here it is.

Best,

Fernando Vizcaino

2020-09-17 Need Help to Get Data by Individual Dates from Calendar Matrix in Excel Spreadsheet 2.yxmd

All comments

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

2020-09-17 Need Help to Get Data by Individual Dates from Calendar Matrix in Excel Spreadsheet.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703