Re: How to redisplay data from MySQL

From: David L (dl_at_nospam.com)
Date: 07/03/04

  • Next message: josh: "Re: newbie can't get form working" 
    Date: Sat, 03 Jul 2004 11:55:10 GMT

    i'm a bit confused by what you mean, but i doubt mysql will help you
    very much. If i were in a similar situation, i'd persist with the Excel
    pivot table, or, if some scripting is called for, i'd be using VBA in
    Excel. For adhoc data manipulation, Access might be better.

    Charles Alexander wrote:

    > Hello
    >
    > I'm trying to redisplay and reorganize some data off a huge Excel
    > spread***. I figured it would be easier to manipulate if I dumped the
    > data into MySQL with the help of phpMyAdmin.
    >
    > I'm a newbie to MySQL and PHP and/or Perl so if someone can lead me in the
    > right direction to accomplish the following.
    >
    > I have a database with 1 table from 5 columns of data.
    >
    > Column 1 Column 2 Column 3 Column 4 Column 5
    >
    > UniqueID A Param1 1Av1 1Av2 1Av3
    > UniqueID A Param2 2Av1 2Av2 2Av3
    > UniqueID A Param3 3Av1 3Av2 3Av3
    > UniqueID A ...
    > UniqueID A ...
    > UniqueID A ParamN Values of ParamN (")
    >
    >
    > UniqueID B Param1 1Bv1 1Bv2 1Bv3
    > UniqueID B Param2 2Bv1 2Bv2 2Bv3
    > UniqueID B Param3 3Bv1 3Bv2 3Bv3
    > UniqueID B ...
    > UniqueID B ...
    > UniqueID B ParamN Values of ParamN (")
    >
    > UniqueID C Param1 1Cv1 1Cv2 1Cv3
    > UniqueID C Param2 2Cv1 2Cv2 2Cv3
    > UniqueID C Param3 3Cv1 3Cv2 3Cv3
    > UniqueID C ...
    > UniqueID C ...
    > UniqueID C ParamN Values of ParamN (")
    >
    >
    > I want to transpose these data to
    >
    > Unique ID Param1 Param2 Param3 ... ParamN
    >
    > A All Corresponding Values ie. v1, v2, v3 for each ID
    > B All Corresponding Values "
    > C All Corresponding Values "
    >
    >
    > The Pivot Table in Excel seems to be perfect for this except that I can't
    > get it to display the actual data values for each Unique ID as opposed to
    > Summaries, Count etc.
    >
    > Any help would be appreciated.
    >
    > Thanks
    >
    > Charles
    >

  • Next message: josh: "Re: newbie can't get form working"