How to use worksheet data shown in other worksheet table?

How to use worksheet data shown in other worksheet table?

Here’s an example on what I’m trying to do…

In one worksheet, I have lists of data like this…

No. Date Person Sex DOB

1 1/3/2017 Andrew M 1/3/1978

2 1/2/2017 Jack M 1/2/1968

3 1/1/2017 Maggie F 1/1/1975

 

Now in other worksheet I want above data shown in different way in other table format…

Date 1/3/2017 DOB 1/3/1978

Person Andrew Sex M

Now how can I get this done using excel function?

Maybe in one cell I just type in the No. and rest of related data could be shown correctly?

Can anyone help on this?

Thanks in advance…

By: Jackson Cheng

Leave a Reply

Your email address will not be published. Required fields are marked *