I want to transpose each row in my worksheet. For example, there are 10 cells in every row that I want to transpose to 10 cells in one column under each row. Each of my row is spaced out and has 10 empty cells (rows) underneath. How can I use the transpose equation and apply it to the row that occurs every 10 rows (there is data on every 10th row after spacing). If I just drag the Transpose equation down, it doesn't work, as it begins to transpose empty cells as well? Basically - How can apply the Transpose equation to every 10th row with data?