Transposing select text from rows to columns

[AndiH]

I have a spreadsheet with rows of data which needs to be moved into columns next to a person's name. Example:

a1:John
a2:Birthdate
a3:Hiredate
a4:Mike
a5:Birthdate
a6:Hiredate

Result needed:
A1: John B1: Birthdate C1: Hiredate

I need to have have the birthdate and hiredates in columns next to the person's name. I cannot use VBA or macros. Excel 2007.

Thank you.

 

[sheetspread]

If your column is a1:a12 then paste this formula in, say b15:

=INDEX($A$1:$A$12,2*(ROW(A1)-1)+ROW(A1),1)

and directly to the right:
=INDEX($A$1:$A$12,2*(ROW(A2)-2)+ROW(A2),1)

and directly to the right:
=INDEX($A$1:$A$12,2*(ROW(A3)-3)+ROW(A3),1)

copy down..........

 

[AndiH]

Almost -- I have different names with details all in one row. The result really needs to be
A1: John B1: Birthdate C1: Hiredate
A2: Mike B2: Birthdate C2: Hiredate

Am I asking too much?

 

[sheetspread]

Excel Workbook
	A	B	C	D	E
1	John		John	1/1/2001	2/2/2002
2	1/1/2001		Mike	3/3/2003	4/4/2004
3	2/2/2002		ted	5/5/2005	6/6/2006
4	Mike		joe	7/7/2007	8/8/2008
5	3/3/2003		ned	9/9/2009	10/10/2010
6	4/4/2004
7	ted
8	5/5/2005
9	6/6/2006
10	joe
11	7/7/2007
12	8/8/2008
13	ned
14	9/9/2009
15	10/10/2010
Sheet3

If you want A1:C5 as your output range instead of C1:E5 then put the data in another column and change the references correspondingly. Unless you want to keep the column as is and put the birthdate and hire date next to each name.