I forgot to mention that to expand the table in b_1 you can just select the cell in the bottom right corner (now S10) and press Tab.
I also forgot to mention that the formulas in b_1Transpose at present are copied to A1:J26. You will have to copy these formulas down and to the right as required. In b_1Transpose you can of course use formatting to hide zeros if you want.
|