title: One-hot (dummy) encoding of categorical data in Excel
body: <p>How to convert categorical data to one-hot encoded numeric format. Output format is depicted in the figure below:
  <a href="https://i.stack.imgur.com/Fcdj4.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fcdj4.jpg" alt="enter image description here"></a></p>
  
  <p>Is it possible to automatically extract data classes and create columns for each class without having to create all columns (White, Red, Black, ...) manually in Excel?</p>