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