Data Totals by Town

[mkeohan]

Hello Everyone,

I am trying to take a list of addresses and somehow export data from that to give me some totals on the heat type. So essentially I want to take the address and simply convert it to just the town name and the totals of heat type for that town. Normally I would do this manually but this list has over 1 million addresses in it. Anyway to expedite this process? Ive got one column that is the town name and one column that is the heat type. Please let me know if you need more information.

 

[Special-K99]

Example data / layout ?

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[mkeohan]

Ok so this is what my spreadsheet looks like. I had to take out some of the personal information contained within. The two columns that I'm concerned with is F and M. Below the data is how I would like it to be presented. Basically just having the town name once and next to it each heat type listed as a total #. Please let me know if you need more information. Thanks

					F							M
			CONSTITUTION AVE	ABINGTON	MA	02351		2308		745	ELC
			CONSTITUTION AVE	ABINGTON	MA	02351		2308		844	ELC
			CONSTITUTION AVE	ABINGTON	MA	02351		2307		719	ELC
			Jennings Dr	Abington	MA	02351		1526		267	Gas
			Jennings Dr	Abington	MA	02351		1526		366	Gas
			Jennings Dr	Abington	MA	02351		1525		475	Gas
			CENTRE AVE	ABINGTON	MA	02351		2229		374	Oil
			CENTRE AVE	ABINGTON	MA	02351		2229		338	Oil
			CHERRY ST	ABINGTON	MA	02351		2514		142	Oil
			Pond St		Avon	MA	02322	02322-1624	1624		431	Gas
			Pond St		Avon	MA	02322	02322-1624	1624		297	Gas
			Pond St		Avon	MA	02322	02322-1624	1624		954	Gas
			KING ST		AVON	MA	02322	02322-1205	1205		058	Oil
			BLANCHARD ST	AVON	MA	02322	02322-1244	1244		064	Oil
			BLANCHARD ST	AVON	MA	02322	02322-1244	1244		082	Oil

<colgroup><col style="width:48pt" width="64" span="5"> <col style="width:48pt" width="64"> <col style="width:48pt" width="64" span="6"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

	ELEC	GAS	OIL
Abington	3	3	3
Avon		3	3

<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</tbody>