Moving Columns of Data

3.76K viewsGeneral Discussion
0

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:

Matrix1:

South Sales Profit
East
West
North

Matrix2:

East Costs Variance
North
West
South

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):

Matrix3:

South Sales Costs Variance
North
West
East

Is there a formula that will drag over just the columns that I want, or is the only option to do a cut&paste?

Thanks!

0

Since there is way to control the value of items by a formula or expression – I think cut and paste is probably your best bet.

If anyone else out there has a different approach to this – please feel free to post.

-Mike

You are viewing 1 out of 6 answers, click here to view all answers.