hello,
I have a little problem. here is my sample excel data. its fairly large.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AAA[/TD]
[TD]AA[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AAA[/TD]
[TD]BB[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]null[/TD]
[TD]null[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]CC[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]DD[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AAA[/TD]
[TD]AA[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AAA[/TD]
[TD]BB[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]null[/TD]
[TD]null[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]CC[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]BBB[/TD]
[TD]DD[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
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?