Ok, say that I have a category that exists in multiple matrices. However, the same category in different matrices may have different columns of data. For example:
South Sales Profit
East Costs Variance
What I would like to do to create a 3rd matrix, with the same category, but showing my own pick of columns(with no changes to the data):
South Sales Costs Variance
Is there a formula that will drag over just the columns that I want, or is the only option to do a cut&paste?