Ordening tekstcells into the right kolom

[Daan123]

Hello,

Im trying to automate ordering my excel sheet based on the text in the cell. 

For example,

All the cells are placed in the wrong kolom. What I want is that the cells are placed (automatically) in the correct kolom like this: 

How can i manage this? (it seems so easy :) )

Thanks!

[#2]

@Daan123 That's not easy at all. How would Excel know what's a name, a color or a fruit? In which group would you put "Orange", for instance?

[#3]

@Riny_van_Eekelen Valid point. And if the cells where fixed? For example, when the "Colour" column can only be blue and red and the "Name" column can only be Ben and Luke? 

From this:

To this:

 or maybe

[#4]

@Daan123 Then I would use Power Query. Attached is a quick-and-dirty solution.