Why do you want to do this? Unless you specifically are wanting to do this for data entry purposes for a legacy system, you would be better off putting your data in a table, and then use a pivot table to produce the output you describe.
Ie, Create a table with the following headings
Sku, description, size, location, quantity.
Then insert a pivot table.
Would that work?
Mallycat,
I understand what you are saying, but it won't work. The primary reason is that the format which the data is in is not recognized by excel as being a list which can be imported into a pivot table.
What I am specifically asking is how to get it into a table format. Perhaps I wasn't clear on that. The headings are not standard and the data falls into a unique format based on how many locations have the product. I am asking how to get my data into a standard format which I could later import into a pivot table.
Thanks!
Last edited by aldek; 04-23-2012 at 12:39 PM. Reason: Clarification
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks