Answer to Question #101445 in Marketing for Mag

Question

Explain how data might be consolidated or converted to allow it to be analysed.

Answer 1

 

For successful consolidation, each data range appears on a worksheet separate from the rest, the range has data listed with labels in the first row, category labels are included, and a similar layout is used across all data ranges, which should also include similar facts. Lastly, no columns or rows should be left blank. After this, “Data Tools” is selected followed by “Consolidate”, both on “Data Ribbons”. An effective and working consolidation method is then picked out, then selection of “data”, “labels”, followed by “Add” is done. This step is repeated for all data workbooks. The “top row”, “left column” and “create links to data source” are then checked when needed, closing with the “OK” button