All geek questions in one place

Convert a vertical address list to a horizontal list in Excel 2010

A simple question, but the one I found the answer to. I have a large list of addresses in a vertical format that I want to change in a horizontal list. Below is an example, basically I want to change the cells to read horizontally, rather than vertically, the cell values ​​for each section in brackets:

Vertical list:

(A1) 12 Norton Street (A2) Warwick (A3) Warwickshire (A4) CV12 3SE

Horizontal list:

 (A1) 12 Norton Street (B1) Warwick (C1) Warwickshire (D1)CV12 3SE

Anyone have any suggestions?

+4
source share
1 answer

I do not know excel 2010, but I can not imagine that this has changed:

Select your vertical address list, go to B1, use "Insert Special" and select the "Transport" checkbox to insert your values ​​transposed. Then delete column A.

+8
source

Source: https://habr.com/ru/post/1382482/

More articles:


All Articles