Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to arrange data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to arrange data
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to arrange data
Excel works best with data laid out in table format, i.e row 1 for headers
and contiguous data beneath. http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm -- Regards Dave Hawley www.ozgrid.com "Amin" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to arrange data
Hi thanks for the advice but i still need some help here.
My data is in columns but am particular with the items how they should go into the sheet. Now we have more than 100 make up items. hould i have all into one column? and have a grouping column and category column as well or which. to help you help me check this eg. Lip items under berries, LIP STICK LIP LINER LIP GLOSS Apple berry d berry berry sparkle rich fig plum berry sugarberry there are other lip items under chocholates, metals, neutrals and so on. now i wanted to have all items in one column then a column for them to be grouped as well as categories. any assistance will be apprecated. the above all falls under berries "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
arrange data | New Users to Excel | |||
How to Arrange Data for Chart | Charts and Charting in Excel | |||
re-arrange cell data | Excel Discussion (Misc queries) | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
arrange data by criteria | New Users to Excel |