P
powderskier9
I need to align data between multiple columns. For example, A, B, C, D
Column A has the source data that I wish to compare against, so fo
example:
Column A Column B Column C
A-1000 A-1010 A-1010 is red
A-1010 A-1020 A-1020 is blue
A-1020 A-1050 A-1050 is white
Basically Column A is the source data column that I need to align th
data from Column B & C with. If I perform a sort it will only work o
one row. So I need to match the Values in Column A with thei
correspondents in Column B & C. I have attached a sample file. This i
matching data between one and many columns.
Thank
Column A has the source data that I wish to compare against, so fo
example:
Column A Column B Column C
A-1000 A-1010 A-1010 is red
A-1010 A-1020 A-1020 is blue
A-1020 A-1050 A-1050 is white
Basically Column A is the source data column that I need to align th
data from Column B & C with. If I perform a sort it will only work o
one row. So I need to match the Values in Column A with thei
correspondents in Column B & C. I have attached a sample file. This i
matching data between one and many columns.
Thank