TRANSPOSE is perfect for this. I’ve used it tons of times to flip data from horizontal to vertical. Just use =TRANSPOSE(range) where range is your horizontal data. So if your data’s in A1 to E1, you’d type =TRANSPOSE(A1:E1) where you want the vertical data to start. Make sure you’ve got enough empty cells below your formula or it’ll throw an error. Best part? It updates automatically when you change the original data. Saves me hours compared to copy-pasting everything manually when I’m restructuring spreadsheets.