Hot to arrange data in a matrix according their values

[juanjoge]

HI!!!

I want to arrange a values in a matrix according 2 values (in this cases benefit and years) as you can see bellow, I try to find examples in how to do this, but I can´t find nothing usefull , Any idea or recommendation in how to do this?

Many thanks advance

 

[StephenCrump]

Welcome to MrExcel!

Check out these two links, with free downloads:

1. Formula approach: Emulate Excel Pivot Tables with Texts in the Value Area using Formulas - Clearly and Simply

2. VBA approach: Emulate Excel Pivot Tables with Texts in the Value Area using VBA - Clearly and Simply

 

[juanjoge]

Great!!! many thanks!!

 

[Fazza]

FYI, another way is to use a cross-tab query: no formulas, no VBA. If you're interested I can look for some old forum posts.

 

[juanjoge]

YES PLEASE, I appreciate a lot yout help!!!

 

[Fazza]

http://www.mrexcel.com/forum/excel-questions/396182-pivot-table-text-values-2.html

http://www.mrexcel.com/forum/excel-questions/384664-can-i-return-text-pivot-table.html

 

[juanjoge]

Excelent, let me check, many thanks!!!!