Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 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:

=TRANSPOSE(INDIRECT("A"&(1+(5*(ROW(B1)-1))&":A"&(4+(5*(ROW(B1)-1))))))

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

 
discard

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.