Filling up each cell in a table by matching row values with column headers

[wuaw]

Hi team,

I have a scenario where I need to create some form of trend analysis. I have done some data massage and have reached the part where I have columns arranged in ascending order (dates) and thousands of rows of dates (converted to string). Both rows and columns are in the same date range. I need to match each row with the corresponding header and populate that cell with value "1"

I wish to get your expertise whether the multi-row formula tool is able to achieve this task. A sample workflow would be greatly appreciated.

Attached are two sample files:

Date_underscore.xlsx

Date_underscore (desired output).xlsx

Thank you

[TheOC]

HI @wuaw 

My Pleasure - Glad I could be a help, and thank you for marking as solution, have a great day!