I have two columns with 4 rows. I want to transpose them to one long row. I have tried:
which works great for one column. I’ve not been able to work out how to get two columns into one row.
Basically my row should look like this : =A1|=B1|=A2|=B2|= A3|=B3|=A4|=B4
This will be need to be scaled. I have only these two columns, but many many rows. Effectively, I would love to choose the start and end point within these two columns, and the selection will then be split up across the row (see image).