Results 1 to 14 of 14

Reorganize data

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2009
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    8

    Reorganize data

    Hello,

    Is there any easy method to tranform the table from Tabel 1 to 2?

    TABLE 1
    Date Name Level
    11/6/2009 A 65.12
    12/6/2009 A 65.84
    13/6/2009 A 24.65
    14/6/2009 A 24.95
    15/6/2009 A 12.95
    16/6/2009 A 74.65
    17/6/2009 A 54.32
    18/6/2009 A 41.95
    19/6/2009 A 65.54
    11/6/2009 B 25.13
    12/6/2009 B 43.21
    13/6/2009 B 65.12
    14/6/2009 B 43.12
    15/6/2009 B 64.24
    16/6/2009 B 65.12
    17/6/2009 B 65.84
    18/6/2009 B 24.65
    19/6/2009 B 24.95
    11/6/2009 C 12.95
    12/6/2009 C 74.65
    13/6/2009 C 54.32
    14/6/2009 C 41.95
    15/6/2009 C 65.54
    16/6/2009 C 25.13
    17/6/2009 C 43.21
    18/6/2009 C 65.12
    19/6/2009 C 43.12

    TABLE 2
    Date A B C
    11/6/2009 65.12 25.13 12.95
    12/6/2009 65.84 43.21 74.65
    13/6/2009 24.65 65.12 54.32
    14/6/2009 24.95 43.12 41.95
    15/6/2009 12.95 64.24 65.54
    16/6/2009 74.65 65.12 25.13
    17/6/2009 54.32 65.84 43.21
    18/6/2009 41.95 24.65 65.12
    19/6/2009 65.54 24.95 43.12
    Last edited by pentiumeric; 07-08-2009 at 06:36 AM. Reason: solved

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