I know that's about as clear as mud, but let me explain: I have to track scans per address, per month. My data is similar to this although for 3272 properties and with the potential for multiple scans per day: Address January February March April May 15 Oak Glen 1 17 High Ridge 8 15 Oak Glen 6 4 Blueberry 1 and I need it to look like this: Address January February March April May 4 Blueberry 1 0 0 0 0 17 High Ridge Run 0 8 0 0 0 15 Oak Glen 1 0 0 6 0 I had previously used a VBA Module that I had found but that was over 2 years ago and for the life of me I cannot locate the information or get the data to work. I'm not worried about it sorting by address, I just need to combine all the results for 1 address into 1 row to show each month's totals as I can manipulate it from there.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

HELP! Combine row data based on column A, but keep data in columns B-M without calculating totals.

Thread starter Ambiguous_Fink
Start date May 19, 2022

Ambiguous_Fink

New Member

May 19, 2022

I know that's about as clear as mud, but let me explain: I have to track scans per address, per month. My data is similar to this although for 3272 properties and with the potential for multiple scans per day:

Address	January	February	March	April	May
15 Oak Glen	1
17 High Ridge		8
15 Oak Glen				6
4 Blueberry	1

and I need it to look like this:

Address	January	February	March	April	May
4 Blueberry	1	0	0	0	0
17 High Ridge Run	0	8	0	0	0
15 Oak Glen	1	0	0	6	0

I had previously used a VBA Module that I had found but that was over 2 years ago and for the life of me I cannot locate the information or get the data to work. I'm not worried about it sorting by address, I just need to combine all the results for 1 address into 1 row to show each month's totals as I can manipulate it from there.