+ Reply to Thread
Results 1 to 4 of 4

Pivot excel without count or sum, just original data

  1. #1
    Registered User
    Join Date
    12-22-2020
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    3

    Pivot excel without count or sum, just original data

    Hi, I have data like this, trying to pivot the data but the result is not as expected
    wondering to make it expected result and to make macro for it, cause this is my routine task. many thanks before
    Attached Images Attached Images
    Last edited by egiyogie; 12-22-2020 at 09:08 AM. Reason: Solved

  2. #2
    Registered User
    Join Date
    12-22-2020
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    3

    Re: Pivot excel without count or sum, just original data

    Sorry for different name on pivot result, i've change the name but somehow still show the initial name

  3. #3
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    681

    Re: Pivot excel without count or sum, just original data

    Row Labels- Name
    Columns- Date
    Value- In & Out
    Change the count to Max
    Format the number to Time
    Remove the grand total
    Pivot table option > Check 'Merge and center cells with labels'
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-22-2020
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    3

    Re: Pivot excel without count or sum, just original data

    Quote Originally Posted by Shareez Saleem View Post
    Row Labels- Name
    Columns- Date
    Value- In & Out
    Change the count to Max
    Format the number to Time
    Remove the grand total
    Pivot table option > Check 'Merge and center cells with labels'
    wow, many thanks for your help

+ 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. [SOLVED] How do I restore original Pivot Table data?
    By Andrew C in forum Excel General
    Replies: 8
    Last Post: 12-14-2016, 03:14 AM
  2. Pivot value as per original data
    By Shadmani in forum Excel General
    Replies: 3
    Last Post: 06-04-2016, 11:52 PM
  3. Add data not in original range to pivot table
    By mfeng in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-03-2013, 02:19 AM
  4. Replies: 0
    Last Post: 09-17-2010, 10:59 AM
  5. Excel 2007 : Pivot tables distort original data source
    By Anudinee in forum Excel General
    Replies: 0
    Last Post: 06-15-2009, 07:58 PM
  6. Original Source of Pivot Table Data
    By akexcel in forum Excel General
    Replies: 3
    Last Post: 05-08-2007, 09:53 AM
  7. Pivot Tables - Can I get back to my original Data
    By Markl in forum Excel General
    Replies: 2
    Last Post: 02-28-2006, 10:01 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