Move 2 Columns and Values into separate Columns for each value formula

[darrenmccoy]

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>

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>

 

[RasGhul]

Try this,

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	CLIENTID	CLIENT TYPE
2	2	Past Owner
3	3	Past Owner
4	695	Owner
5	6	Past Owner
6	6	Owner
7	6	Past Vendor
8	13	Past Owner
9	13	Past Owner
10	14	Purchased
11	15	Past Owner
12
13	Client ID	Appraisal	Buyer	Owner	Past Buyer	Past Owner	Past Vendor	Purchased	Purchaser	Sold By Other	Vendor
14	2					TRUE
15	3					TRUE
16	6			TRUE		TRUE	TRUE
17	13					TRUE
18	14							TRUE
Sheet1

Cell Formulas
Range	Formula
B14	=IF(ISNUMBER(MATCH($A14&B$13,INDEX($A$2:$A$11&$B$2:$B$11,),0)),"TRUE","")

 

[darrenmccoy]

Thank you!

Works very well. And it works in google sheets as well.

 

[RasGhul]

Awesome, thanks for the feedback.