Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows to columns
I'm writing here as I couldn't find any way of achieving what I need
using Excels built-in modules so probably the only way is through some code. I have a list of addresses that were imported to Excel and they are all in one column. I need to get them to be in multiple columns. E.g. I have 2 or 3 lines of one address in one cell so here I would need to get each line in a separate column which would give 3 columns with addresses and then underneath another cells with bits of address and so on . Hope it makes sense. Can someone help me with this please? yaro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel see columns as rows and rows as columns | Excel Discussion (Misc queries) | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |