Thanks for your reply..

But that is not what i need. Below is an example

I have a excel worksheet, sheet1 contains these data

Category Sub Category

Bike ...