hello,
I have a little problem. here is my sample excel data. its fairly large.
<tbody>
</tbody>
So i want to change the values in column A and B. so i want to input a number (1-5) in column B and values of column A and B should change according to that number. For example if put 1 in B1, values of A1 should be AAA and value of B1 should be AA. again if i put 4 in b2 value of A2 should be BBB and value of B2 should be CC. How i can do that?
I have a little problem. here is my sample excel data. its fairly large.
A | B | C | D | E |
AAA | AA | 1 | ||
AAA | BB | 2 | ||
null | null | 3 | ||
BBB | CC | 4 | ||
BBB | DD | 5 |
<tbody>
</tbody>
So i want to change the values in column A and B. so i want to input a number (1-5) in column B and values of column A and B should change according to that number. For example if put 1 in B1, values of A1 should be AAA and value of B1 should be AA. again if i put 4 in b2 value of A2 should be BBB and value of B2 should be CC. How i can do that?