Struggling to import an excel sheet similar to the below(the original sheet actually has more variants like License, Optical Drive etc).
I want to be able to import from the format below(all of 1 assets attributes are all in the same row, but different columns). Can someone please tell me what drop down I need to choose for each attribute? So far if I choose "attribute" on each column it only imports one of the attributes. Thanks
Warehouse | Customer | Asset Tag | OEM Serial | Item Description | Working Status(attribute) | Model (attribute) | Processor (attribute) | Hard Drive (attribute) | Memory (attribute) |
J | ABC | J193002 | GUX2028898 | HP Desktop | Working A Grade | Core i5 | 2400 3.1GHz | 250GB | 8GB |
J | ABC | J193003 | FHSOIW | HP Desktop | Working A Grade | Core i5 | 2400 3.1GHz | 500GB | 4GB |
J | ABC | J193004 | FFJKSWO | HP Desktop | Working A Grade | Core i3 | 3470 3.2Ghz | 250GB | 8GB |
J | Test 3 | J193005 | HHDKEIW | DELL Desktop | Working A Grade | Core 2 Duo | e8400 3.0GHz | 128GB SSD | 2GB |
J | Test 3 | J193006 | IIUISWS | Lenovo Desktop | Working A Grade | Xeon | e5500 2.4GHz | 320GB | 16GB |