Consolidating data

[wolfep93]

Census.xlsxHi

I'm a fairly advanced Excel user but I'm stuck.

Me and my associate are working through census data to form a database aof sorts. We currently have all the data we need in an Excel Spreadsheet and now we need to consolidate some of it down.
We have a column with the town's name and then we have all that town's data in the rows to its right.

SnipImage.jpg

You'll notice:
The towns column has many duplicate towns listed and we want one row per town.
The duplicate towns listed have data that is not the same and we want the sum of each column (town's data) with only one town listed.

We aren't entirely sure how we can do this but are certain it can be done.

Please explain a way to do this as simply as possible.

Any help will be thouroughly appreciated.
Thanks.

[AB33]

It could be done using a macro (Code). If you want a code solution, please attach your sample.

[oeldere]

Show us an excel file, without confidentional information.

Please also add the desired (expected) result.

[wolfep93]

not entirely sure how to post the spreadsheet itself but here is the data



RI Bristol Barrington town 133.000000 26.00 5.00 12.00 2.17 13.00 12.00
RI Bristol Barrington town 145.000000 41.00 5.00 18.00 2.28 20.00 14.00
RI Bristol Barrington town 131.000000 41.00 2.00 14.00 2.93 14.00 13.00
RI Bristol Barrington town 57.000000 15.00 1.00 6.00 2.50 8.00 6.00
RI Bristol Barrington town 44.000000 25.00 6.00 10.00 2.50 10.00 9.00
RI Bristol Barrington town 117.000000 0.00 0.00 0.00 0.00 0.00 0.00
RI Bristol Barrington town 87.000000 279.00 74.00 135.00 2.07 154.00 65.00
RI Bristol Barrington town 105.000000 13.00 7.00 5.00 2.60 6.00 5.00
RI Bristol Barrington town 128.000000 17.00 5.00 9.00 1.89 9.00 9.00
RI Bristol Barrington town 99.000000 22.00 2.00 10.00 2.20 11.00 8.00
RI Bristol Barrington town 28.000000 28.00 4.00 12.00 2.33 13.00 11.00
RI Bristol Barrington town 61.000000 126.00 13.00 43.00 2.88 45.00 40.00
RI Bristol Barrington town 42.000000 22.00 2.00 6.00 3.67 6.00 6.00
RI Bristol Barrington town 94.000000 13.00 1.00 6.00 2.17 7.00 6.00
RI Bristol Barrington town 91.000000 28.00 7.00 9.00 3.11 10.00 7.00

[oeldere]

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[wolfep93]

alright a portion of the spreadsheet is linked in the original post

[oeldere]

with an pivot table.

but since you only show 1 town and one state you can't see all the avange of an pivot table.

see the attached file.

[wolfep93]

fantastic!

thank you

[VKS]

Hie there, please check the attached file.... is this how you would want to see it.... VKS