Results 1 to 14 of 14

tranpose range of column data into row

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Lightbulb tranpose range of column data into row

    I have a raw data set that looks like following

    ID DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 DATA7 DATA8
    a 15 3 4 1 13 5 5 6
    b 12 15 8 15 10 13 8 4
    c 3 1 1 13 9 13 15 13
    d 13 3 2 4 3 12 14 8
    e 10 12 7 8 1 2 9 10

    I want to transpose the data including the header to something like this

    ID TYPE DATA
    a DATA1 15
    a DATA2 3
    a DATA3 4
    a DATA4 1
    a DATA5 13
    a DATA6 5
    a DATA7 5
    a DATA8 6
    b DATA1 12
    b DATA2 15
    b DATA3 8
    b DATA4 15
    b DATA5 10
    b DATA6 13
    b DATA7 8
    b DATA8 4
    c DATA1 3
    c DATA2 1
    c DATA3 1
    c DATA4 13
    c DATA5 9
    c DATA6 13
    c DATA7 15
    c DATA8 13
    d…
    d…
    d…
    ..


    e…
    e…
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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