I am trying to transpose horizontal cell data to vertical columns.
I select the row data, click cut, click on new cell, click paste special.
The screen has one selection of “unformatted text”, I click OK and it pastes in rows.
I have no “paste all” or “transpose” options so cannot perform the transpose I need.
Thanks in advance for any help.