将内容从1列移动到3列 [英] Move content from 1 column to 3 columns
问题描述
我有这个内容的长文件:
I have long file with this content:
John Doe1
Street Foo 35
New York
Mary Johnson
Street Foo 49
Los Angeles
Robert Deniro
Street Bar 47
Washington
...
正如你所看到的,有一列名称,地址,城镇,名称,地址,城镇..
As you can see there is one column with Name, Address, Town, Name, Address, Town..
我想将其自动转换为一个3列的文件:
I would like to convert it automatically to a file with 3 colums:
John Doe1 Street Foo 35 New York
Mary Johnson Street Foo 49 Los Angeles
Robert Deniro Street Bar 47 Washington
...
可以吗?
Excel 2007 / Windows 7
Excel 2007/Windows 7
推荐答案
根据这个类似的答案,假设您的数据位于A1:A50(您可以根据需要在以下公式中扩展此范围),然后:
Based on this similar answer, and assuming your data lays in A1:A50 (you can extend this range in the formulas below as needed), then:
单元格B1: = INDEX($ A $ 1:$ A $ 50,ROW()* 3-2,1)
单元格C1: = INDEX($ A $ 1:$ A $ 50,ROW()* 3-1,1)
单元格D1: = INDEX($ A $ 1:$ A $ 50,ROW()* 3,1) c $ c>
Cell D1: =INDEX($A$1:$A$50,ROW()*3,1)
这给你一行重新排列的数据。根据需要复制B1:D1向下。
This gives you one line of rearranged data. Copy B1:D1 downwards, as far as needed.
这篇关于将内容从1列移动到3列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!