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!
Bookmarks