MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 242|Reply: 3

Creating Pivot on Database Split on 7 Sheets

[Copy link]

1

Topics

2

Posts

7

Integral

Newbie

Rank: 1

Integral
7
Post on 2-11-2017 14:15:03 | All posts |Read mode
Hi guys,
Nice to meet you, I'm Marco and I'm Italian
I'm here as I need help in order to build a pivot table that is driving me crazy :\ The matter is that I have a database that is so huge that it is split into two sheets (each sheets has the same headers) and, starting from it, I need to create a pivot...
I created a simple version of the file I'm working on that I'm attaching to the post, just for your understanding.
The problem is that, as you will see, in the pivot I cannot use Country as a label, as Excel includes it in the label Columns... Is there a solution for this? In the original file I have kinda 10 columns more in the database that I cannot use as labels.
Many thanks in advance!!!

Marco








  • Aiuto Pivot.xlsx
    (16.4 KB, 2 views)
    Download








  • Reply

    Props Report

    10

    Topics

    903

    Posts

    1996

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1996
    Post on 2-11-2017 15:25:19 | All posts
    Reply Support Opposition

    Props Report

    10

    Topics

    903

    Posts

    1996

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1996
    Post on 2-11-2017 21:21:49 | All posts
    Reply Support Opposition

    Props Report

    1

    Topics

    2

    Posts

    7

    Integral

    Newbie

    Rank: 1

    Integral
    7
     Author| Post on 2-11-2017 21:50:29 | All posts



    So basically I can merge columns in which I have values, but not those in which I have texts... right?
    I mean.. there is no way of having a label Country showing France and Australia?
    Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:37 , Processed in 0.130553 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!