I am currenty learning pivot table in excel. I am trying get a table that has "Cities" in the first column and "adresses" in the second column in tabular form. The cities comes out nice but the adresses are not correct. All the adresses is printed out for every city, even though they dont belong to that city.
Hoe should I fix this?
It should be looking like the attachment.
Bookmarks