Listen Inn is correct; the linked discussion answers essentially the same question as you asked.
Think of the first column (A) in the Data table as holding the Make of the piece, the second (B) the Model, and the third (C) the serial number.
Column D (labelled "Store") contains the location information.
The last column contains an index. made up of the Location and a count of items in that location from the top of the Data table to the current row.
Set up the table and formulas as shown in the the other discussion, then insert columns after column B or C until you have enough column for your date.
Enter oyur data, and you should be good to go.