Is there a signle command which will 'flip' a worksheet so that columns become rows? (or vice versa)
C captain fantastic Mar 10, 2008 #1 Is there a signle command which will 'flip' a worksheet so that columns become rows? (or vice versa)
S Stefi Mar 10, 2008 #2 Select your Currentregion>Copy>PasteSpecial to the required destination (possibly to a blank sheet) transpose checked. Regards, Stefi „captain fantastic†ezt Ãrta:
Select your Currentregion>Copy>PasteSpecial to the required destination (possibly to a blank sheet) transpose checked. Regards, Stefi „captain fantastic†ezt Ãrta:
M Max Mar 10, 2008 #4 Dang, line: .. responses in .worksheet.functions as well. Click to expand... should read: ... responses in .public.excel & in .newusers Click to expand... ---
Dang, line: .. responses in .worksheet.functions as well. Click to expand... should read: ... responses in .public.excel & in .newusers Click to expand... ---
