Thread: [Solved] Transposing a worksheet
View Single Post
 
Old 04-23-2017, 09:16 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote