excel Excel Matrix To Column Press AltDP Multiple Consolidation ranges Next I will create Page Fields Next 6. This will open the…