Inquiry Background:
I have an excel worksheet generated by company reporting software that gives me claims data for analytics. Each row is a claim with corresponding information in designated columns. Sometimes a claim gets duplicated for multiple rows as prescribers linked to the claim have differing designations that our system generates. I am seeking a VBA code that merges rows in a worksheet that has equal data in all columns but differ in columns K and L. Upon completing the merger i would like column K and L differing values to be separated by a space. This would allow for the consolidation of claims that should have been on one row but have been split up to multiple rows due to the differences in column K and L. VBA code should act on the entire worksheet spanning from Column A:Q. See below for data visual.
I have an excel worksheet generated by company reporting software that gives me claims data for analytics. Each row is a claim with corresponding information in designated columns. Sometimes a claim gets duplicated for multiple rows as prescribers linked to the claim have differing designations that our system generates. I am seeking a VBA code that merges rows in a worksheet that has equal data in all columns but differ in columns K and L. Upon completing the merger i would like column K and L differing values to be separated by a space. This would allow for the consolidation of claims that should have been on one row but have been split up to multiple rows due to the differences in column K and L. VBA code should act on the entire worksheet spanning from Column A:Q. See below for data visual.