Hello!
I have a table that I need to Index Match a code and date to another sheet. The problem is that there are multiple lines for each person and the code I need is not always the first one.
<TBODY>
</TBODY>
I need to pull the data into something like this;
<TBODY>
</TBODY>
I have a table that I need to Index Match a code and date to another sheet. The problem is that there are multiple lines for each person and the code I need is not always the first one.
Name | Employee # | Code | Code Date |
ABC | 1 | TA | 2018/1/1 |
ABC | 1 | TZ | 2018/2/1 |
BCD | 2 | TA | 2018/5/31 |
FGH | 3 | TZ | 2018/2/4 |
BCD | 2 | TZ | 2018/6/1 |
<TBODY>
</TBODY>
I need to pull the data into something like this;
Name | Employee # | TA Code | TA Date | TZ Code | TZ Date |
ABC | 1 | TA | 2018/1/1 | TZ | 2018/2/1 |
BCD | 2 | TA | 2018/5/31 | TZ | 2018/6/1 |
FGH | 3 | TZ | 2018/2/4 |
<TBODY>
</TBODY>