Forum Discussion
unequal tables
Hi there, my columns are unequal: see attached (yellow columns). How can I equalize them to column 1, to have proper data in rows? Thank you for any tips.
WassimN I have commodity good code in column B, D, F, H, K for annual value of import (column C, F, H, J, L). All these goods codes should correspond to the code in the first column (all codes list). They do not. See pic.
Hello Eliza55
Looking at Row 22:
A22 has 305, B22 has 403. Should B22 be 305? C22 has 334708.362 this should be on Row 28 (C28) because A28 is 403 and B22 is 403?
Please let us know...
Looking at Row 22:
A22 has 305, B22 has 403. Should B22 be 305? C22 has 334708.362 this should be on Row 28 (C28) because A28 is 403 and B22 is 403?
Please let us know...
WassimN yes, your interpretation is righ. I need all rows equal according to column A, and together with the values (B&C, E&F, G&H, ...)
So, according to A22, in B22 should be "305" which is now in B17, and "empty cell", which is now in C17.
-- according to A28, in B28 should be "403" which is now in B22, and "334708.362", which is now in C22
-- according to A31, in b31 should be "406", which is now in B25, and "107648323.903", which is now in C25
etc....