+ Reply to Thread
Results 1 to 2 of 2

Powerpivot not merging ??

  1. #1
    Registered User
    Join Date
    05-09-2018
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    86

    Powerpivot not merging ??

    Dear all,

    I was trying to merge the cost and revenue sheet into one merged sheet as to come up with the margin of each course No. (column A), but when i merge them, all the roles are not showing?? could anyone help with this??

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Powerpivot not merging ??

    Hello,

    what Power Pivot? The data model in your attachment is empty.

    What steps did you take exactly to merge the tables? What column has the key on which to merge? Please explain the expected outcome in context. Maybe use a smaller data sample to keep things simple.

+ 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. Replies: 1
    Last Post: 11-02-2017, 09:20 PM
  2. [SOLVED] Allow use of Slicers on PowerPivot to be used by users without PowerPivot
    By weeble33 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-09-2017, 05:19 PM
  3. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  4. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  5. Replies: 0
    Last Post: 11-20-2012, 05:34 AM
  6. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  7. Merging cells/merging cell content.
    By rhintintin in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 10:42 AM

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