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

Ambiguous_Fink

New Member
Joined
May 19, 2022
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
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:

AddressJanuaryFebruaryMarchAprilMay
15 Oak Glen1
17 High Ridge8
15 Oak Glen6
4 Blueberry1

and I need it to look like this:

AddressJanuaryFebruaryMarchAprilMay
4 Blueberry10000
17 High Ridge Run08000
15 Oak Glen10060

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.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,224,829
Messages
6,181,218
Members
453,024
Latest member
Wingit77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top