list 在 Excel 2010 上将垂直地址列表转换为水平列表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8226686/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Transform vertical address list to horizontal list on Excel 2010
提问by DVP
A simple question, but one where i have found an answer to yet. I have a large list of addresses in vertical format that i want to change to a horizontal list. Below is an example, basically i want to change the cells to read accross horizontal rather than down vertically, 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?
有人有什么建议吗？
回答by Jens Hoffmann
I don't know excel 2010 but I can't imagine this has changed:
我不知道 excel 2010，但我无法想象这已经改变了：
Select your vertical list of addresses, go to B1, use "Paste special" and check the "Transpose" checkbox to paste your values transposed. Delete column A afterwards.
选择您的垂直地址列表，转到 B1，使用“选择性粘贴”并选中“转置”复选框以粘贴转置的值。之后删除A列。
