Results 1 to 5 of 5

Pivot table for columns

Threaded View

dineshsilicon Pivot table for columns 10-20-2011, 11:24 PM
dineshsilicon Re: Pivot table for columns 10-24-2011, 11:03 PM
arlu1201 Re: Pivot table for columns 10-28-2011, 02:26 PM
lima Re: Pivot table for columns 10-28-2011, 06:45 PM
jpr73 Re: Pivot table for columns 10-31-2011, 06:36 AM
  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003 (in Office) Excel 2007 (in Home)
    Posts
    21

    Pivot table for columns

    Hi,

    I have two columns of data, need to create a PIVOT table, which have to give the output one after another.

    First Column :Device
    Second Column : Montype
    Pivot table output should come like.

    Device/Monserver:
    -> Here it should show the device name first, followed by the Montypeit has from the next row, lilke this for every device its corresponding monserver should come below.

    I attached the sample input and output, please see that to get a idea. I want to know the steps how to perform to get the output.

    Any help is much appreciated,

    Thank you,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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