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?

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 ...