How to get this output in Excel

Sanjay Gandhi
Sanjay Gandhi used Ask the Experts™
on
Hi,

How to get this Pivot output or formula driven output based on data.
File is attached.Get-Output.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
You can simply insert a pivot table. Please refer to the attached for details.
Get-Output.xlsx
Sanjay GandhiFounder, Kenhal

Author

Commented:
Cool :)
Tried earlier, but must have missed something. Sometimes simple answers are simply away.

Thanks boss.
Sanjay GandhiFounder, Kenhal

Author

Commented:
Cool :)
Tried earlier, but must have missed something. Sometimes simple answers are simply away.

Thanks boss.
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Sanjay! Glad I could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial