Help in Pivot

[murthysri272]

Hi,
I am new to Excel Macros/Excel LOOKUP Functions.
Could anyone please help me to get sample code/Formula for below Scenarios:

I have 4 colums.
Column1 has "S.No" from 1 to 10000 (Has duplicated records)
Column2 has "Name" from A to Z (Has duplicated records)
Column3 has "Subjects" as Math, ENGLISH, History, Science
Column4 has "Marks"

Example data as below
SNo Name Subject Marks
1 AB MATH 55
2 BC ENG 44
1 AB HIST 66
2 BC SCI 88

I would like to pivot subject column to row and display output.

Regards,
Srirama

[mdmackillop]

Hi Srirama
It's easier for everyone if you post a sample workbook

[Bob Phillips]

So why don't you just pivot subject column to row? You seem to know what you want, you obviously know of pivots, so what is the issue?

[murthysri272]

Attached sample

[Bob Phillips]

Apart from the fact that that is subject in columns not rows, and you haven't included all of the marks in the results, that is a standard pivot. So I repeat, what is the issue?

[Paul_Hossler]

Yes, a standard regular ol' run of the mill PT would work for that

Is there something special that is not shown in your example?


19984