Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Further Question about Transpose
Hello everybody,
I have a single column of texts with the following pattern: Row 1: Company Name Row 2: Address Row 3: Tel Row 4: Fax Row 5: Website For example: ABC Company Ltd 20/F, Abc Building, 1 Abc Street, ABC Country 1111 1111 2222 2222 www.Abc.com. XYZ Ptd Ltd Suite 5008 €“ 5010, 50/F, XYZ Building, 7 XYZ Street, XYZ Country 3333 3333 4444 4444 www.xyz.com (and so on €¦) The length of such column is not fixed. So can I use €śPaste Special - Transpose€ť or =TRANSPOSE(array) to transform the data that column A contains all company names, column B contains all addresses, column C contains all tel num. and so on? (The €śPaste Special - Transpose€ť transformed all data in a single row. But I want to transform the record line €“ by €“ line without moving again €¦) Much appreciate if any tips about this. Thank you!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |