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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago