Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert column to row
I have a list of several hundred staff in a column - see below
(A1) title firstname last name (A2)address 1 (A3) address2 (A4) city state postcode (a5) Phone (A6) skill1 (a7) skill2 (a8) skill3 [number of skills varies between 1-8] (a9)blank row (a10) title firstname last name of person 2 how would I convert this to a row for each person - (splitting out the name field into three cells and transposing all other cells - then starting in the next row with the next person - see below (A1) title (B1) firstname (c1) lastname (d1) add1 etc ... [skills n=1-8] (A2) title (b2) firstname ... I have about 500 entries to convert - so if you could help it would be very very much appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert column to row
actually looking at this (a4) needs to be split into three columns as well as
(a1) "FSM" wrote: I have a list of several hundred staff in a column - see below (A1) title firstname last name (A2)address 1 (A3) address2 (A4) city state postcode (a5) Phone (A6) skill1 (a7) skill2 (a8) skill3 [number of skills varies between 1-8] (a9)blank row (a10) title firstname last name of person 2 how would I convert this to a row for each person - (splitting out the name field into three cells and transposing all other cells - then starting in the next row with the next person - see below (A1) title (B1) firstname (c1) lastname (d1) add1 etc ... [skills n=1-8] (A2) title (b2) firstname ... I have about 500 entries to convert - so if you could help it would be very very much appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert column to row
From what I can see the switch over is compounded by the "variable
number of skill entries". This means that you would need to use VB to repeat the "skills" line until you see a blank line. FSM wrote: actually looking at this (a4) needs to be split into three columns as well as (a1) "FSM" wrote: I have a list of several hundred staff in a column - see below (A1) title firstname last name (A2)address 1 (A3) address2 (A4) city state postcode (a5) Phone (A6) skill1 (a7) skill2 (a8) skill3 [number of skills varies between 1-8] (a9)blank row (a10) title firstname last name of person 2 how would I convert this to a row for each person - (splitting out the name field into three cells and transposing all other cells - then starting in the next row with the next person - see below (A1) title (B1) firstname (c1) lastname (d1) add1 etc ... [skills n=1-8] (A2) title (b2) firstname ... I have about 500 entries to convert - so if you could help it would be very very much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert one column into five | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How do I convert a column from USD to GBP | Excel Discussion (Misc queries) | |||
Can I convert a column into a row? | Excel Discussion (Misc queries) |