Hi-

I need some excel tips in trying to figure out the following data that have multiple columns and value into one columns without eliminating the original first two or three columns.

Original data:

First Last Number1 Qty1 Number2 Qty2 Number3 Qty3 Number4 Qty4
AAA BBB CCC 5 DDD 5 EEE 6 FFF 7
GGG HHH III 1 JJJ 2

Final product:

First Last Number1 Qty1
AAA BBB CCC 5
AAA BBB DDD 5
AAA BBB EEE 6
AAA BBB FFF 7
GGG HHH III 1
GGG HHH JJJ 2

Is there a faster way to do this without copy and pasting each column?

thanks!
Stephani