Hi,
I am trying to automate large amounts of data analysis. Data structure and expected data analysis snapshot is attached.
I believe macros can do it, but not quite competent to achieve this..any help will be greatly appreciated!!!
Assumptions
Data starts from Row 2- Headers in row 1
Column A...