Hi thank you for the quick response, this VBA works for this raw data provided in the sample workbook, but the actual data I'm handling have 50+ properties(meaning 50+rows) and hundreds of columns(because there are even more dates, and ever month new data is uploaded). hence is there a configuration to this current VBA to have a loop?