I have an excel spreadsheet which is the result of exporting data from a crystal report
The crystal report has data from a sub report and apparently the following exists
"The export to Excel is designed to export the subreport to the "next" row. There is nothing you can do about that."
So is it possible to have a macro that puts the data under the correct headings and removes the blank rows
Have attached the excel file
Example the figures in row 3 should be in row 2 under the headings:- Reg Hrs Qty Reg Hrs Cost O/T Hrs Qty O/T Factor OT Hrs Cost Total Hrs Cost
Noting that some records do not contain data to move (example row 65)