murthysri272
08-04-2017, 12:13 AM
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
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