I am trying to get the Crystal reports that show on two lines to export into a single line per record so i can squish the data around in excel. Any thoughts?
Specifically, i am looking at the failed logins report and I want the account names to show in a single column so I can do things like easily tell the number of times a particular account was attempted or the variety of account names per server that were attempted. this will help me look for outliers and potentially problematic attack vectors I need to fortify or adjust.
Thanks!