Need Excel copy and paste help
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
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago