+ Reply to Thread
Results 1 to 4 of 4

how to display 2 fields in row as in different column

  1. #1
    Registered User
    Join Date
    11-28-2017
    Location
    Jeddah
    MS-Off Ver
    2010
    Posts
    23

    Thumbs up how to display 2 fields in row as in different column

    sheet and picture is attached please let me know how i can put barcode column A then item in column b and outgoing in column C in the pivot table as you can see barcode and item are over lapsing each other..thank you in advance
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: how to display 2 fields in row as in different column

    Hi there,

    Not sure I understand what exactly your requirements are, but if it is just a re-layout of the pivot table, have a look at the attached file.

    Basically, click inside the PivotTable, then under PivotTable Tools, click Design, then Report Layout, then Show in Tabular Form.

    Hope this helps.
    Attached Files Attached Files
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  3. #3
    Registered User
    Join Date
    11-28-2017
    Location
    Jeddah
    MS-Off Ver
    2010
    Posts
    23

    Re: how to display 2 fields in row as in different column

    Thank you so much Oroos i exactly needed that ...

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: how to display 2 fields in row as in different column

    You are welcome fslrules.

    If that answered your question, please take the time to mark this tread as SOLVED.

    Thanks !

+ 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] Display row if entered fields are in that row
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2021, 07:08 AM
  2. Dont want to display fields containing #DIV/0!
    By qjumper in forum Excel General
    Replies: 2
    Last Post: 04-28-2019, 01:25 AM
  3. Display Blank Fields As Blanks
    By arturo5 in forum Excel General
    Replies: 3
    Last Post: 03-20-2013, 10:46 AM
  4. Display only selected fields in a PivotTable with VBA
    By S30 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 09:41 PM
  5. Array Formula if 2 fields = display 3
    By brownjc0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2010, 09:48 PM
  6. Differentiate between column fields and data fields in a pivot table
    By whiteheadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2009, 01:59 PM
  7. [SOLVED] how do I enter a value, display that many fields?
    By Ant in forum Excel General
    Replies: 1
    Last Post: 06-09-2006, 12:25 PM

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