Data generated over multiple lines-EXCEL

Copper Contributor

I work with Microsoft Dynamics GP at the office. We use it to generate various reports and databases that we need in Excel. The issue is that when we attempt to generate the reports in CVS or TXT to import them into excel, the reports will generate the information for one customer over multiple lines. 

This makes it hard for us to sort through and manage the data in an efficient way. We currently use a combination of sorting and copy-pasting data. But I am sure there is a better way to do this. I am just not that knowledgeable about Excel to figure out how to do it. 

 

Any help would be appreciated.

1 Reply
If you're able to upload a sample or paste a snippet of the data, that would help in getting you a quick solution.