horizontal data to show in vertical column inn excel10

[PKBrahma]

	Table 1 data is in Sheet1
	Names	Date of Birth	Designation	Pay
1	Hari	15-06-1990	Clerk	14600
2	Ramesh	26-03-1998	Head Clerk	22000
3	Madhu	12-05-2001	Administrator	26000
4	Govinda	24-08-1993	Receptionist	16000
5	Henry	07-01-2000	Warden	14500
6	Arthur	23-12-1991	Supervisor	18000
	Table 2 data to see in sheet2
	Names	Hari
	Dt of Birth	15-06-1990
	Designation	Clerk
	Pay	14600

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Sir,
How can I show Table1 data in Table2 format in a different sheet ? I want one sheet for one name to see data. Horizontal data are many mores(say 11 columns). Each name will show 10 columns one below the other. Is it possible?
Thank you.

 

[Lology]

As I understood your question, it can be done by using INDEX MATCH functions with Names in a dropdown list, and the other cells (Date of Birth, Designation and Pay) will change according to the name you will choose from the dropdown list.

 

[jim may]

Excel 2010

	A	B	C	D
1	Names	Hari	Ramesh	Madhu
2	Date of Birth	15-06-1990	26-03-1998	37230
3	Designation	Clerk	Head Clerk	Administrator
4	Pay	14600	22000	26000

<tbody>
</tbody>

Sheet2​

Note Correction (In Yellow) of Inconsistent use of field-name.

In Cell B1 (above) enter:

[TABLE]
<tbody>[TR]
[TD]=OFFSET(Sheet1!$A$1,COLUMN()-1,)[/TD]
[/TR]
</tbody>[/TABLE]

and copy across.

then in Cell B2 (above) enter:

[TABLE]
<tbody>[TR]
[TD]=INDEX(Sheet1!$B$2:$D$7,MATCH(B$1,Sheet1!$A$2:$A$7,0),MATCH(Sheet2!$A2,Sheet1!$B$1:$D$1,0))[/TD]
[/TR]
</tbody>[/TABLE]

and copy across AND down.

Your Column A Values (Constants) should PRE-EXIST on your Sheet2 - meaning you should enter as Values

Hope that helps.....