This question is is regarding Excel. I am using Association Rule Generator from Analytic solver for the following data; but the Association Rule can only handle binary (0/1) values. How to code variables such as ID, M, R, F, and FirstPurchase, so that they are 0 and 1?

Description of the variables are herein below:

ID# Gender R. FirstPurch ChildBks - YouthBks CookBks DoltyBks RefBks ArtBks GeogBks ItalCook - oo ItalHAtlas oooo ItalArt oooooooooo Florence O0O OOO 10 12 0 138 28 3 1 240 141 1 97 6 2 1 348 2 7 023920 2 1 253 10 4 1 118 16 1 1 326 14 2 1 249 12 3 1 294 10 12 1 301 2 2 1 219 32 2 0227 30 2 1 328 26 12 1 54 14 3 1 196 2 12 1 88 10 2 0109 8 4 0 257 14 12 1 207 4 7 1 265 16 1 1 69 14 2 30 59 89 96 120 128 131 139 177 181 188 231 245 289 320 335 342 355 381 396 408 0 1 0 1 0 1 0 0 1 1 0 0 1 1 1 1 0 0 1 1 0 1 14 10 38 28 20 16 22 20 58 4 40 34 62 22 26 16 18 76 22 16 18 1 0 0 1 0 0 1 1 0 1 0 0 0 1 1 1 0 0 1 1 1 0 0 0 0 1 1 0 0 0 0 1 0 1 0 0 1 1 1 1 1 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 1 0 0 0 13 1 0 0 1 1 0 0 0 0 1 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 22 23 -- Seq# ID# Gender M R F FirstPurch ChildBks YouthBks CookBks DoltYBks RefBks ArtBks GeoBks ItalCook ItalAtlas ItalArt Florence Sequence number in the partition Identification number in the full (unpartitioned) market test data set O=Male, 1=Female Monetary-Total money spent on books Recency-Months since last purchase Frequency - Total number of purchases Months since first purchase Number of purchases from the category: Child books Number of purchases from the category: Youth books Number of purchases from the category: Cookbooks Number of purchases from the category Do It Yourself books Number of purchases from the category: Reference books (Atlases, Encyclopedias, Dictionaries) Number of purchases from the category: Art books Number of purchases from the category: Geography books Number of purchases of book title: "Secrets of Italian Cooking." Number of purchases of book title: "Historical Atlas of Italy." Number of purchases of book title: "Italian Art." =1 "The Art History of Florence." was bought, = 0 if not ID# Gender R. FirstPurch ChildBks - YouthBks CookBks DoltyBks RefBks ArtBks GeogBks ItalCook - oo ItalHAtlas oooo ItalArt oooooooooo Florence O0O OOO 10 12 0 138 28 3 1 240 141 1 97 6 2 1 348 2 7 023920 2 1 253 10 4 1 118 16 1 1 326 14 2 1 249 12 3 1 294 10 12 1 301 2 2 1 219 32 2 0227 30 2 1 328 26 12 1 54 14 3 1 196 2 12 1 88 10 2 0109 8 4 0 257 14 12 1 207 4 7 1 265 16 1 1 69 14 2 30 59 89 96 120 128 131 139 177 181 188 231 245 289 320 335 342 355 381 396 408 0 1 0 1 0 1 0 0 1 1 0 0 1 1 1 1 0 0 1 1 0 1 14 10 38 28 20 16 22 20 58 4 40 34 62 22 26 16 18 76 22 16 18 1 0 0 1 0 0 1 1 0 1 0 0 0 1 1 1 0 0 1 1 1 0 0 0 0 1 1 0 0 0 0 1 0 1 0 0 1 1 1 1 1 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 1 0 0 0 13 1 0 0 1 1 0 0 0 0 1 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 22 23 -- Seq# ID# Gender M R F FirstPurch ChildBks YouthBks CookBks DoltYBks RefBks ArtBks GeoBks ItalCook ItalAtlas ItalArt Florence Sequence number in the partition Identification number in the full (unpartitioned) market test data set O=Male, 1=Female Monetary-Total money spent on books Recency-Months since last purchase Frequency - Total number of purchases Months since first purchase Number of purchases from the category: Child books Number of purchases from the category: Youth books Number of purchases from the category: Cookbooks Number of purchases from the category Do It Yourself books Number of purchases from the category: Reference books (Atlases, Encyclopedias, Dictionaries) Number of purchases from the category: Art books Number of purchases from the category: Geography books Number of purchases of book title: "Secrets of Italian Cooking." Number of purchases of book title: "Historical Atlas of Italy." Number of purchases of book title: "Italian Art." =1 "The Art History of Florence." was bought, = 0 if not