Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function?
Hello to all, I'm just wondering if someone could help me with this issue. I have the following: MemberID Call code Area code 1 A 709 2 C 709 3 D 709 1 B 645 2 C 645 3 A 645 I want to Transpose the above table to look like the following: Area Code MemberID 709 645 1 A B 2 C C 3 D A I've tried using a pivot table but I cannot get around the issue whereby when I drag over the Call code column into the Data space it automatically wants to carry out a Function on my text data (call code column). What I hope to do is use the pivot table technique to just click & drag my text data over as is, without having the pivot table try and calculate some function. Is this possible within Excel? Or should I be using another procedure within Excel to accomplish this? Thanks very much for any help I can get! -- Excel-erate2004 ------------------------------------------------------------------------ Excel-erate2004's Profile: http://www.excelforum.com/member.php...fo&userid=6897 View this thread: http://www.excelforum.com/showthread...hreadid=512867 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) |