Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm having 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?

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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