+ Reply to Thread
Results 1 to 2 of 2

Combining Data into a Single Pivot

  1. #1
    Registered User
    Join Date
    03-21-2019
    Location
    Barcelona
    MS-Off Ver
    365
    Posts
    1

    Combining Data into a Single Pivot

    Hi,

    I will try to explain what i want to do....

    I have a budget i want to show a sum by expense category (payroll, rent, etc) over a year (Jan, Feb, Mar...)
    This data is in 2 tabs, one for HR one for all other.

    How do i essentially combine 2 pivot tables that can be created by these tab data? There is not common index between them.

    See the tabs in the sample file.....the Wished Pivot is what i want to do....

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Combining Data into a Single Pivot

    Arrange your data in one RecordSet
    Then Pivot
    Attached Files Attached Files

+ 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. Combining multiple columns data into a single column
    By tmor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2016, 07:12 PM
  2. Combining seperate data into single spreadsheet
    By profitdr123 in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-11-2015, 12:03 PM
  3. [SOLVED] Combining the data from different Workbooks to One single Worksheets
    By mhraja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2014, 03:41 PM
  4. Combining row data into single row to create timeline
    By cubmar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2013, 06:39 AM
  5. Combining multiple rows of data into a single row
    By jhsiao in forum Excel General
    Replies: 3
    Last Post: 12-12-2012, 11:20 AM
  6. Replies: 2
    Last Post: 05-03-2012, 01:18 PM
  7. Replies: 2
    Last Post: 02-02-2012, 09:49 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