Change multiple Excel cells (column) into one field instead of multiple rows? - beginner question
I've been tasked with taking a dump from a computer inventory program and creating a searchable FM database from the data. The problem is how the inventory program exports some fields. Fields with one piece of data (model, memory, serial number) are easy. Fields with a lot of data are not so easy; the data is exported in multiple rows (under the same column header). The result, when I import the Excel document, is hundreds of records with most fields blank instead of one record.
I can manually select the data and merge the fields to fix this one file, but I need to import a dump that will contain dozens if not hundreds of computers. I'm looking for a method that might help me simplify this process - especially if/when I have to update the information with an updated import.
I've attached a screenshot of the Excel 'dump' so you can see the problem. When importing the file I'm getting a record for every row. Since I cannot modify the dump from the inventory program I need to work with the data.
Any help would be greatly appreciated.