1) Use "AutoFilter" (Data>Filter>AutoFilter) and filter for non-blanks. · 2) Copy remaining cells · 3) Paste Special (Edit>Paste Special) and select "Transpose" ...
確定! 回上一頁