If I have formatted data inputted from the most top-left cell to the right (A1, A2, A3, A4, A5), how do I copy it to SHEET 2 but in a different direction, this time from top to bottom (A1, B1, C1, D1, E1). What I need is the formula itself.
When I try to copy-paste, it always ends up pasting on the copied direction.
Thanks for the help!![]()
Bookmarks