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
Solved! Go to Solution.
HI @wuaw
My Pleasure - Glad I could be a help, and thank you for marking as solution, have a great day!