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!

Hello excelor,

Welcome or the Forum!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

excelor,

Welcome to the Excel Forum.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.