Excel Help - GoFuckYourself.com

96ukssob · 10-18-2012, 09:39 AM

Huge brain fart today, most likely due to lack of sleep.

So what I have is a bunch of records for real estate listings, about 5,000 or so. They all belong to 8 different cities, so what I want to do is remove the duplicates and create a condensed table.

So for instance, it would be: City, School District. Then I could have City, Neighborhood. etc. I tried setting this up in a pivot table but I need the records to be in ROWS because I need to add other data beside it.

In the case of the school district, there is say 600 listings in one city with 4 school districts, so I want to essentially weed out the duplicates.

thanks

96ukssob · 10-18-2012, 09:40 AM

Forgot to mention, I'm NOT looking to filter, but create these "tables" in a NEW tab for each

Nad · 10-18-2012, 01:14 PM

Select Insert and then a Pivot table.. you can drag and drop what you want in there.

10-18-2012, 09:39 AM	#1
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	Excel Help Huge brain fart today, most likely due to lack of sleep. So what I have is a bunch of records for real estate listings, about 5,000 or so. They all belong to 8 different cities, so what I want to do is remove the duplicates and create a condensed table. So for instance, it would be: City, School District. Then I could have City, Neighborhood. etc. I tried setting this up in a pivot table but I need the records to be in ROWS because I need to add other data beside it. In the case of the school district, there is say 600 listings in one city with 4 school districts, so I want to essentially weed out the duplicates. thanks __________________ Email: Clicky on Me

10-18-2012, 09:40 AM	#2
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	Forgot to mention, I'm NOT looking to filter, but create these "tables" in a NEW tab for each __________________ Email: Clicky on Me

10-18-2012, 01:14 PM	#3
Nad Confirmed User Join Date: Feb 2003 Posts: 503	Select Insert and then a Pivot table.. you can drag and drop what you want in there. __________________ Racecar spelled backwards is Racecar! A MAN A PLAN A CANAL PANAMA 202740086