Change data format from poly-nominal to bi-nominal?

[Ali Majed]

Greetings

I have a large data-set of transactions in a market that is in poly-nominal format. How can I change it into bi-nominal?

From:

001,milk,cheese,bread

002,butter,bread

To:

TID,milk,cheese,butter,bread

001,1,1,0,1

002,0,0,1,1

[#2 · Accepted solution]

Assuming the same layout as your screen-shot:

formula in cell A6: =A2
formula in cell B6:F7: =IF(ISERROR(MATCH(B$5,$B2:$E2,0)),0,1)

[#3]

GREAT! Thanks in Advance