Excel hide column formula

Hello,

I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items.

The drop down list is located on top of my sheet1 and give the possibility to see my data either in infos, détails or contact

My sheet1 contains info, detials and contact data and I would just like it if I choose contact that infos and détails rows ( that I would have identified) would hide.

Thanks a lot !