How do you transpose a cell to a zero in Excel? If you need to convert all blank cells to zeros, use the Transpose feature.

You can easily convert horizontal data to vertical and vertical data to horizontal by using the Transpose feature in Excel.