Instead, using transpose automatically fills blanks to zeros. Read: How to split one single long column into multiple columns in Excel How do you transpose text in Microsoft Office?

Hidden in Calc's Paste Special option, the Transpose feature enables you to convert data listed across a row, so it appears in a column. This conversion also works on tables, so that header rows ...