![]() |
Pivot Table or Grouping Help
I want the following data to appear in an Excel spreadsheet like so and I
don't know whether a Pivot Table is the answer or not. I just want this to look more presentable if I can. Can anyone help me??? Thanks in advance... DataTrac Object Name Item Type Security Bucket Sec. 1 Sec. 2 Sec. 3 ACT1-Broker Check Amount FIELD ACT Security 1=Don't View 2=View Only 2=View Only DOC Security 1=Don't View 2=View Only 2=View Only FUN Security 1=Don't View 2=View Only 2=View Only GEN Security 1=Don't View 2=View Only 2=View Only INS Security 1=Don't View 2=View Only 2=View Only MKT Security 1=Don't View 2=View Only 2=View Only SHP Security 1=Don't View 2=View Only 2=View Only SRV Security 1=Don't View 2=View Only 2=View Only SYS Security 1=Don't View 2=View Only 2=View Only UND Security 1=Don't View 2=View Only 2=View Only |
All times are GMT +1. The time now is 03:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com