helprb123
08-11-2014, 12:00 PM
I have a (hopefully) quick excel question.
I have 3 columns of data that look like the following:
Car 1 Match
Car 2 Match
Car 3 Match
#N/A
A
#N/A
#N/A
#N/A
B
#N/A
#N/A
B
S
#N/A
#N/A
A
#N/A
#N/A
#N/A
A
#N/A
S
#N/A
#N/A
This data is in 3 columns because I put in formulas that will extract the car identifier from other sheets with matching information. Now I need only 1 column that displays this information. I need a 4th column that will combine all of the sets so I have the following:
Car 1 Match
Car 2 Match
Car 3 Match
Car
#N/A
A
#N/A
A
#N/A
#N/A
B
B
#N/A
#N/A
B
B
S
#N/A
#N/A
S
A
#N/A
#N/A
A
#N/A
A
#N/A
A
S
#N/A
#N/A
S
I need 1 column that will show me the car identifier. Any thoughts on how to do this?
Thank you!
I have 3 columns of data that look like the following:
Car 1 Match
Car 2 Match
Car 3 Match
#N/A
A
#N/A
#N/A
#N/A
B
#N/A
#N/A
B
S
#N/A
#N/A
A
#N/A
#N/A
#N/A
A
#N/A
S
#N/A
#N/A
This data is in 3 columns because I put in formulas that will extract the car identifier from other sheets with matching information. Now I need only 1 column that displays this information. I need a 4th column that will combine all of the sets so I have the following:
Car 1 Match
Car 2 Match
Car 3 Match
Car
#N/A
A
#N/A
A
#N/A
#N/A
B
B
#N/A
#N/A
B
B
S
#N/A
#N/A
S
A
#N/A
#N/A
A
#N/A
A
#N/A
A
S
#N/A
#N/A
S
I need 1 column that will show me the car identifier. Any thoughts on how to do this?
Thank you!