horizontal data to show in vertical column inn excel10

[PKBrahma]

[TABLE="width: 382"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Table 1 data is in Sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Names[/TD]
[TD]Date of Birth[/TD]
[TD] Designation[/TD]
[TD] Pay[/TD]
[/TR]
[TR]
[TD="align: right"]1 [/TD]
[TD]Hari[/TD]
[TD="align: right"]15-06-1990 [/TD]
[TD] Clerk[/TD]
[TD] 14600[/TD]
[/TR]
[TR]
[TD="align: right"]2 [/TD]
[TD]Ramesh[/TD]
[TD="align: right"]26-03-1998 [/TD]
[TD] Head Clerk[/TD]
[TD="align: right"]22000[/TD]
[/TR]
[TR]
[TD="align: right"]3 [/TD]
[TD]Madhu[/TD]
[TD="align: right"]12-05-2001 [/TD]
[TD] Administrator[/TD]
[TD="align: right"]26000[/TD]
[/TR]
[TR]
[TD="align: right"]4 [/TD]
[TD]Govinda[/TD]
[TD="align: right"]24-08-1993 [/TD]
[TD] Receptionist[/TD]
[TD="align: right"]16000[/TD]
[/TR]
[TR]
[TD="align: right"]5 [/TD]
[TD]Henry[/TD]
[TD="align: right"]07-01-2000 [/TD]
[TD] Warden[/TD]
[TD="align: right"]14500[/TD]
[/TR]
[TR]
[TD="align: right"]6 [/TD]
[TD]Arthur[/TD]
[TD="align: right"]23-12-1991 [/TD]
[TD] Supervisor[/TD]
[TD="align: right"]18000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Table 2 data to see in sheet2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Names[/TD]
[TD]Hari[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Dt of Birth[/TD]
[TD]15-06-1990[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Designation[/TD]
[TD]Clerk[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pay[/TD]
[TD]14600[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
Names
Designation
Pay

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]Hari[/TD]
[TD="align: center"]Ramesh[/TD]
[TD="align: center"]Madhu[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFF00"]Date of Birth[/TD]
[TD="align: right"]15-06-1990[/TD]
[TD="align: right"]26-03-1998[/TD]
[TD="align: right"]37230[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]Clerk[/TD]
[TD="align: right"]Head Clerk[/TD]
[TD="align: right"]Administrator[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]14600[/TD]
[TD="align: right"]22000[/TD]
[TD="align: right"]26000[/TD]

</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.....