May 04 2022 06:40 AM
May 04 2022 06:57 AMSolution
Let's say that you want the "transposed" range to start in cell E5.
Enter the following formula in that cell:
If you want to start in another cell, change E5 and $E$5 accordingly.
Fill to the next 4 cells to the right, then fill down.