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 snapshot below. 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.
I would prefer a non-pivot table solution if possible.
Thank you in advance!
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 snapshot below. 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.
I would prefer a non-pivot table solution if possible.
Thank you in advance!