How to import data of a specific row (selectable) from one sheet to another

[xls_fan]

Hi,

I have a workbook in which sheet1 has some column headings like "Serial Number", "Name", "Age", "Height", "Weight" and the rows have values for these column headings of different people . I need to arrange sheet2 as a bio-data format where "Serial Number", "Name", "Age", "Height", "Weight" will be row headings and the cells next to these row headings will import values for different people from sheet1. I like to call data of a specific person in sheet2 by his "Serial Number".

Please help me out.

Thanks in advance.

[José Augusto]

Suppose your data in Sheet1!A1:E99 where row one has column labels "Serial Number", "Name", "Age", "Height", "Weight"
Suppose, in Sheet2!A2:A6 has Rows labels (column labels but transposed).
In B3 use (and copy down) the following formula

Please Login or Register  to view this content.

See the file

[xls_fan]

Suppose your data in Sheet1!A1:E99 where row one has column labels "Serial Number", "Name", "Age", "Height", "Weight"
Suppose, in Sheet2!A2:A6 has Rows labels (column labels but transposed).
In B3 use (and copy down) the following formula

Please Login or Register  to view this content.

See the file

Hi José Augusto,

Yes, it works fine. Your help is much appreciated. Thanks a lot

[José Augusto]

You are welcomed.