Hi Folks

Im a little rusty when it comes to data handling with excel and Im having some issues with a report I have exported from an accounting product (Sage line 50 2012) its a list of customers, when the data exports from line 50 it exports the customers in Rows (heavens knows why!) Its going to be a nightmare to change this from line 50 end, Im wondering is there a way I can import the Data from the report.xls from line 50 into columns in my new excel spreadsheet?

Thanks
James