I have a good old list with addresses:

enter image description here

Because I want to re-arrange the list (and make it more 2013), I need to transpose the list like this:

enter image description here

I've tried to use the TRANSPOSE formula, but that doesn't work.

Is there some other way?


If the data has the same repetition as shown in your example, throughout the list, then the following formula would help you out:


Copy the formula downwards until it hits a ref#.

I've included a Google Spreadsheet file for you to take a look: Transpose an Address List

Good luck with your 2013-ish address list.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.