Hi everyone,
I am trying to setup a reconciliation file that fits multiple needs of different entities. Basically, I have two tables. They are supposedly extracting the same information from two different sources: the total cost of a material split by multiple cost components. The type and number of cost components may differ among entities.
One of the tables extracts the cost components in rows, the other source extracts them in columns (I don’t know if I must transpose the data or not). I have to make it as simple as possible considering the final users may have different levels of knowledge in excel. Could you please tell me what would be the best way to approach this exercise and which formulas could I use?
Thank you in advance
I am trying to setup a reconciliation file that fits multiple needs of different entities. Basically, I have two tables. They are supposedly extracting the same information from two different sources: the total cost of a material split by multiple cost components. The type and number of cost components may differ among entities.
One of the tables extracts the cost components in rows, the other source extracts them in columns (I don’t know if I must transpose the data or not). I have to make it as simple as possible considering the final users may have different levels of knowledge in excel. Could you please tell me what would be the best way to approach this exercise and which formulas could I use?
Thank you in advance
