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

Attached Images

	Clip_75.jpg (100.9 KB, 13 views)
	Clip_76.jpg (101.3 KB, 11 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

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

Thank you for the answer Pecoflyer. this does help.

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

Attached Images

Clip_97.jpg (108.7 KB, 9 views)

Attached Files

pt.xlsx (14.0 KB, 9 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.

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

very much appreciated Pecoflyer. it did work. just i tried some options in the design mode as you have indicated.

many thanks

Jamal

Attached Images

	Clip_106.jpg (100.5 KB, 7 views)
	Clip_107.jpg (94.6 KB, 7 views)
	Clip_108.jpg (97.5 KB, 8 views)
	Clip_109.jpg (97.1 KB, 7 views)

__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank.