Dear all.,
Im new in using excel, and Im not a computer expertise.
Im sorry if I'm not using the right term in excel.
Here is my problem, I was given a bulk of data which consist about 20K information.
I need to arrange the data accordingly from 2 different Excel worksheets; Excel A and Excel B.
What i need to do is i have to transfer the FUNCTION from Excel B to FUNCTION in excel A.
The ID from Excel A may sometimes absent in Excel B, same goes to Excel B.
Moreover the ID can be redundant in Excel A.
Here is an example;
Excel A
A B 1 ID FUNCTION 2 S1 3 S2 4 S4 5 S4 6 S6 7 S7 8 S9 9 S9 10 S12 11 S15
Excel B
A B C 1 ID NAME FUNCTION 2 S1 ALAN SLEEP 3 S2 NATHAN EAT 4 S3 ANNA READ 5 S4 DANIEL SWIM 6 S10 ROBERT PULL 7 S11 SAMUEL PUSH 8 S12 SID SPEAK 9 S13 ALEX SHOUT 10 S14 HARRY RUN 11 S15 TIM WALK
What I need to do is, I have to arrange the data accordingly, as a result of this in Excel A:
Excel A
A B 1 ID FUNCTION 2 S1 SLEEP 3 S2 EAT 4 S4 SWIM 5 S4 6 S6 NA 7 S7 NA 8 S9 NA 9 S9 10 S12 SPEAK 11 S15 WALK
As you can see, the ID in Excel A that have no pairs with any FUNCTION in Excel 2 is written as NA.
Any redundancy of data, only the first will have the FUNCTION, and the following will be blank space.
The NAME in Excel B is not required in Excel A.
Can anyone help me to sort this problem?
It really needs to take me weeks to solve this by copy and paste for thousands of data.
Your help is very appreciated.
Thank you.
Bookmarks