| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Columns to row variable data
Hi
I need to convert column data into row data From this Name Address Fred 30 Jones St London Sue Tower 42 London EC2 To this Name Address1 Address2 Address3 Fred 30 Jones St London Sue Tower 42 London EC2 I have a macro that can convert but the problem is that each person address is has a variable amount of fields. Any way round this Thanks for any help David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to convert a table of data to columns only | Excel Discussion (Misc queries) | |||
| Convert muliple data into columns | Excel Discussion (Misc queries) | |||
| Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
| How do I convert some data in the row to columns? | Excel Discussion (Misc queries) | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
Threaded Mode
