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 |
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) |