Results 1 to 3 of 3

Need Help Tranposing Values

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2011
    Location
    dilse
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need Help Tranposing Values

    Hi Users,

    Thank you in advance! I have been looking for ways to transpose values from "Original Sheet" to "Expected Sheet" , as shown in the example below.. From past few months, it's been tiresome copying and pasting values manually using keyboard and I am losing focus on my real work. Any VLOOKUP or VB scipt would be a great help. T,F,Q,K,C/K refer to sizes and Numbers refer to quantities for items in my example.
    Also, I need to able to skip sizes and quantities that have no or zero values.

    Original Sheet (This is what I have)

    T F Q K C/K
    Serta Black 7 8 0 10 0
    Sealy Brown 7 0 8 10 1
    King Koil White 0 7 8 10 0


    Expected Sheet (This is what I want to produce)


    Serta Black T 7
    Serta Black F 8
    Serta Black K 10
    Sealy Brown T 7
    Sealy Brown Q 8
    Sealy Brown K 10
    Sealy Brown C/K 1
    King Koil White F 7
    King Koil White Q 8
    King Koil White K 10


    Attached is the same sample.

    ....Thanks again!
    Attached Files Attached Files
    Last edited by excelor; 02-26-2011 at 10:44 PM. Reason: Forgot to Include Sample Excel File

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