Forum Discussion

nlanthier2988's avatar
nlanthier2988
Copper Contributor
Jan 26, 2023

Data generated over multiple lines-EXCEL

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.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    If you're able to upload a sample or paste a snippet of the data, that would help in getting you a quick solution.

Resources