Pivoting Data for value

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivoting Data for value

  1. #1
    New Member
    Join Date
    Sep 2003
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivoting Data for value

     
    I have a worksheet that looks something like this:

    Product Fruit Type Size
    Product1 Apples Red Delicious L
    Product2 Apples Red Delicious M
    Product3 Apples Golden S

    I am trying to pivot the data to look like this:

    Product Classification Detail
    Product1 Fruit Apple
    Product1 Type Red Delicious
    Product1 Size L
    Product2 Fruit Apple
    Product2 Type Red Delicious
    Product2 Size M
    Product3 Fruit Apple
    Product3 Type Golden
    Product3 Size S


    Other than a pivot table is there any other way to accomplish this?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivoting Data for value

    Yes, using this query and the Excel ODBC driver...

    SELECT List.Product, 'Fruit' , List.Fruit
    FROM `Book3`.List List
    UNION
    SELECT List.Product, 'Type' , List.Type
    FROM `Book3`.List List
    UNION
    SELECT List.Product, 'Size' , List.Size
    FROM `Book3`.List List
    ORDER BY List.Product

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book3.xls___Running: xl2002 XP : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    ProductFruitTypeSize ProductClassificationDetail
    2
    Product1ApplesRed DeliciousL Product1FruitApples
    3
    Product2ApplesRed DeliciousM Product1SizeL
    4
    Product3ApplesGoldenS Product1TypeRed Delicious
    5
    Product2FruitApples
    6
    Product2SizeM
    7
    Product2TypeRed Delicious
    8
    Product3FruitApples
    9
    Product3SizeS
    10
    Product3TypeGolden
    11
    12
    13
    Sheet1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    New Member
    Join Date
    Sep 2003
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivoting Data for value

      
    Perfect, thank you very much.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com