Results 1 to 2 of 2

Pivot Table repeating the column

Threaded View

  1. #1
    Registered User
    Join Date
    02-29-2024
    Location
    London
    MS-Off Ver
    2021 (365)
    Posts
    1

    Pivot Table repeating the column

    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.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Repeating fields in pivot table source
    By mrCy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-21-2021, 09:14 AM
  2. Pivot table - repeating layout
    By oolaef in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2017, 05:27 AM
  3. Repeating field name in pivot table
    By swchoi89 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-24-2013, 01:34 PM
  4. Replies: 0
    Last Post: 06-11-2012, 10:28 AM
  5. Repeating row labels in a pivot table
    By alderran in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2010, 06:16 AM
  6. repeating names in row fields of a pivot table
    By Jack N in forum Excel General
    Replies: 1
    Last Post: 08-18-2006, 11:40 AM
  7. [SOLVED] Repeating data in a Pivot table
    By Alicia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1