|
|
#1
02-12-2012, 02:14 PM
|
|||
|
|||
Is this sort of pivot possible in the Excel?
Is this sort of pivot possible in the Excel?
In the attached screenshot, I wanted to pivot the given table such that the output is as shown in the screenshot. The regular pivot of the excel gives a categorize data (screenshot 2), but what I’m looking for is to repeat the common value in a separate column (as shown in the screenshot 1) Is this possible in the Excel? Thank you in advance for the help Best Jamal 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel 2010 Pivot Table Qs
|
SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |
| Excel sort problem | jaz | Excel | 2 | 01-16-2011 04:24 AM |
| Can I sort a Pivot table by subtotals? | oshkosh | Excel | 1 | 12-07-2010 06:20 PM |
| linking Excel pivot into PowerPoint formatted | nhegler | PowerPoint | 0 | 11-22-2010 08:05 AM |
| Linking Excel Pivot Tables in a Word Document | wmarsh3561 | Word Tables | 0 | 11-17-2009 06:29 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode