darrenmccoy
New Member
- Joined
- Mar 26, 2019
- Messages
- 37
- Office Version
- 2019
Could someone help me with a lookup formula to move the data from (46k rows) to columns and rows? The person is the CLIENTID. The CLIENTID has multiple CLIENT TYPES. See my example:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 61px"><col width="79"><col width="57"><col width="73"><col width="74"><col width="75"><col width="85"><col width="81"><col width="83"><col width="88"><col width="75"><col width="75"><col width="89"><col width="80"></colgroup><tbody>
</tbody>
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
LOOK UP DATA | NEW DATA | ||||||||||||
CLIENTID | CLIENT TYPE | Client ID | Appraisal | Buyer | Owner | Past Buyer | Past Owner | Past Vendor | Purchased | Purchaser | Sold By Other | Vendor | |
2 | Past Owner | 2 | TRUE | ||||||||||
3 | Past Owner | 3 | TRUE | ||||||||||
695 | Owner | 6 | TRUE | TRUE | TRUE | ||||||||
6 | Past Owner | 13 | TRUE | ||||||||||
6 | Owner | 14 | TRUE | ||||||||||
6 | Past Vendor | ||||||||||||
13 | Past Owner | ||||||||||||
13 | Past Owner | ||||||||||||
14 | Purchased | ||||||||||||
15 | Past Owner |
<colgroup><col style="width: 61px"><col width="79"><col width="57"><col width="73"><col width="74"><col width="75"><col width="85"><col width="81"><col width="83"><col width="88"><col width="75"><col width="75"><col width="89"><col width="80"></colgroup><tbody>
</tbody>