Thread: [Solved] Is this sort of pivot possible in the Excel?
View Single Post
 
Old 02-12-2012, 02:14 PM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question 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
Attached Images
File Type: jpg Clip_75.jpg (100.9 KB, 15 views)
File Type: jpg Clip_76.jpg (101.3 KB, 13 views)
Reply With Quote