It is better to have 4 or 5 columns such as below;which would help to
summarize information based on category,group etc;

Category
Group
Product name
Product code
Price


--
Jacob (MVP - Excel)


"Amin" wrote:

Hi i am about eating an inventory database for a small makeup store, however
thier product are many in terms of category and group. you have the lip
glosses , lip liners, eye liners and so many others like skin care stuff.
what will be the best way to arrange this data should i put all the product
in one colum or seperate them into their own columns. pls advice thank you