Jan 25 2023 05:27 AM
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.
Jan 25 2023 05:50 AM
Jan 25 2023 06:00 AM
@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.
Jan 25 2023 06:18 AM
Jan 25 2023 06:24 AM
Jan 25 2023 06:26 AM
Jan 26 2023 04:22 AM
@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....