Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need some help with pivot
hi,
Im trying to do a pivot table where the value is the actually text and not a count or something. example: client id type data 1 email 1 fax 212 1 ofice 213 1 web ww.a.com 2 email 2 fax 215 i want the result to be: client id email fax ofice web 1 212 213 ww.a.com 2 215 and not (this is what i get) client id email fax ofice web 1 1 1 1 1 2 1 1 can anyone please help me out on this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need some help with pivot
This translates
your Pivot Table to a text Table: (Excel 2003 with Macros) http://www.freefilehosting.net/download/3d8ma |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |