All,
I need to show clients in a pivot table according to two criteria.
Here is the raw data
<TBODY>
</TBODY><COLGROUP><COL span=3></COLGROUP>
Here is the result I am looking for.
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
Please show me how to do this in excel.
I need to show clients in a pivot table according to two criteria.
Here is the raw data
Client</SPAN> | type</SPAN> | Region</SPAN> |
client A</SPAN> | Bank</SPAN> | East</SPAN> |
client B</SPAN> | Fund</SPAN> | East</SPAN> |
client C</SPAN> | Broker</SPAN> | East</SPAN> |
client D</SPAN> | Bank</SPAN> | East</SPAN> |
client E</SPAN> | Bank</SPAN> | West</SPAN> |
client F</SPAN> | Fund</SPAN> | West</SPAN> |
client G</SPAN> | Broker</SPAN> | West</SPAN> |
client H</SPAN> | Bank</SPAN> | West</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=3></COLGROUP>
Here is the result I am looking for.
Region | ||
Type | East | West |
Bank | client A client D | client E client H |
Fund | client B | client F |
Broker | client C | client G |
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
Please show me how to do this in excel.