Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Grouping dates in a pivot table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |