| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change vertical data into horizintal table
I have data provided as a vertical set of information and need to able to
convert it to a table ie Name1 Address1 Tel No1 Name2 Address2 Tel No2 change to :- Name1 Address1 Tel No 1 Name2 Address2 Tel No 2 Any ideas please? -- Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change vertical data into horizintal table
If you list contains only data, no labels
try this: Col_A contains the list, beginning in A1 C1: =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($C:C)) Copy C1 across through E1 Copy those formulas down as far as you need. Using your example, these values are returned in C1:E2 Name1 Address1 Tel No1 Name2 Address2 Tel No2 Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Big Mac" wrote in message ... I have data provided as a vertical set of information and need to able to convert it to a table ie Name1 Address1 Tel No1 Name2 Address2 Tel No2 change to :- Name1 Address1 Tel No 1 Name2 Address2 Tel No 2 Any ideas please? -- Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i change pivot table to change data | Excel Discussion (Misc queries) | |||
| change table from vertical to horizontal | Excel Discussion (Misc queries) | |||
| how do I change the size of vertical scroll bar | Excel Discussion (Misc queries) | |||
| How do I change my typing from horizontal to vertical | Excel Worksheet Functions | |||
| How do I change my text direction to vertical on EXcell? | New Users to Excel | |||
Linear Mode
