Create 2D Matrix of Values From Data in 3 Columns Using Lookups

Hi there,

I am looking to essentially create a 2D matrix of of revenue information, where the revenue value in column 1 will be plotted in the matrix depending on the fiscal year in column 2 and the fiscal quarter in column 3.

I have attached a sample worksheet. You'll not in the FY21 section of the matrix, I have FY21 in the row above each quarter (Q1-Q4), while in the FY22 section, I have only included "FY22" above Q1. I would prefer not to have the fiscal year in each column above the quarters (ie. the layout of FY22), if possible, but if not I am fine with the layout of FY21.

Thank you in advance!

Thanks, but was hoping for a non-pivot table solution, if possible.

Thanks again.