#1
|
|||
|
|||
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
||||
|
||||
EDIT Click your PT - Under the PT Tab select Design - select report Layout in the Layout group - Click Repeat All Items Labels
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post Last edited by Pecoflyer; 02-13-2012 at 05:09 AM. Reason: Answer |
#3
|
|||
|
|||
Quote:
i tried it, but it didn't work. i couldn't the get the values repeated. the file and the screenshot are attached what might be the problem? regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
||||
|
||||
Works perfectly for me under XL2010
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
very much appreciated Pecoflyer. it did work. just i tried some options in the design mode as you have indicated.
many thanks Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
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 |