This question has been flagged

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

WarehouseCustomerAsset TagOEM SerialItem DescriptionWorking Status(attribute)Model

  (attribute)  

Processor

  (attribute)  

Hard Drive

  (attribute)  

Memory

  (attribute)  

JABCJ193002GUX2028898HP DesktopWorking A GradeCore i52400 3.1GHz250GB8GB
JABCJ193003 FHSOIWHP DesktopWorking A GradeCore i52400 3.1GHz500GB4GB
ABCJ193004FFJKSWOHP Desktop Working A GradeCore i33470 3.2Ghz250GB8GB
JTest 3J193005HHDKEIWDELL DesktopWorking A GradeCore 2 Duoe8400 3.0GHz128GB SSD2GB
JTest 3J193006IIUISWSLenovo DesktopWorking A GradeXeon e5500 2.4GHz320GB 16GB

   

Avatar
Discard