+ Reply to Thread
Results 1 to 3 of 3

Pivots table with column duplication

  1. #1
    Registered User
    Join Date
    07-10-2023
    Location
    Barcelona, Spain
    MS-Off Ver
    365
    Posts
    2

    Pivots table with column duplication

    Hi everyone,
    I have a question to ask for help here.
    I was doing the theatre occupancy plan by pivots table. But I get a duplication of two columns. Here is the plan attached in this post.
    The question is, I checked the data base serveral times, there's no problem but I don't understant why there is a duplication. I selected "do not repeat item labels" in "Design-Report layout", it didn't work.

    So I post this to ask for help. If someone has the solution, it would be great!!!! If someone has the same question as this, we can interchange some info to find out the problem together.

    I'm looking forward to the respons, thank you everyone here!!!

    Weixin Screenshot_20230713123305.png

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Pivots table with column duplication

    One must be different from the other in order for them both to be showing in the pivot.
    The first thing that I would check would be that there are not any spaces in one and not the other.

    For example:
    " 29" or "29 " or " 29 "

  3. #3
    Registered User
    Join Date
    07-10-2023
    Location
    Barcelona, Spain
    MS-Off Ver
    365
    Posts
    2

    Re: Pivots table with column duplication

    Hi!!!!
    It's solved!!!! U r right, but I thoungt the same when I found this question, I checked all, at first I didn't figue it out. There is a space there before "29". Maybe there are more than 270.000 datas so my computer didn't run well when I filtrated them!!!

    Thank you so much!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need some help on summarize 3 pivots table in one
    By Yaliv1 in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 03-01-2023, 01:31 PM
  2. [SOLVED] TRUE / FALSE result - ROW Duplication / Duplication in ROW
    By Sherwood_2022 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2022, 06:07 PM
  3. [SOLVED] Formatting Table duplication
    By CDandVinyl in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 12-29-2020, 05:34 PM
  4. Stop Duplication of table
    By pm.patel189 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2018, 05:56 PM
  5. Create a third table from two others, without duplication
    By Hezcal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2015, 10:19 AM
  6. [SOLVED] Pivots Table filter
    By so_nice3 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-13-2014, 02:05 AM
  7. [SOLVED] See if a table has any associated pivots?
    By JungleJme in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2013, 11:23 AM

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