FA Accountant
New Member
- Joined
- Feb 13, 2019
- Messages
- 3
Hi, I need some help to put the following data into an excel pivot so that I can look at any Oracle Role and see only those responsibilities that apply (ie where the X exists - I don't want to see any of blank cells_). Is there a way of doing this? A regular pivot does not seem to work.....thks!
<colgroup><col width="265" style="width: 199pt; mso-width-source: userset; mso-width-alt: 9691;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <tbody>
</tbody>
Oracle Role | AP User | AP Inquiry | AP Manager | GL Inquiry | GL User | FA Inquiry | FA User | FA Manager |
Oracle Role AP Team member | X | X | ||||||
Oracle Role AP Team Lead | X | X | ||||||
Oracle Role Projects Team Member | X | |||||||
Oracle Role Projects Team Lead | X | X | ||||||
Oracle Role Fixed Asset Team Member | X | X | X | |||||
Oracle Role Fixed Asset TeamLead | X |
<colgroup><col width="265" style="width: 199pt; mso-width-source: userset; mso-width-alt: 9691;"> <col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <tbody>
</tbody>