answersLogoWhite

0

It brings data from several source areas together and can do things like total them or other operations. If you have two sets of data, you can combine them into one single set of data without doing it through a formula. It can be done based on position, so you could have two lists of values and add them together. You can also combine them by category. So you could have several values under different headings with more than one set, so that there are lots of values for each. So say you have a number of years with a total for each month in each year. You could consolidate the data so that all the individual January totals are added together and given as one single total.

User Avatar

Wiki User

12y ago

What else can I help you with?