I have an excel file with certain data that needs to output in a certain format by rearranging data and removing blank fields.
There is an attached file and the instructions are on 1st tab
2nd tab 'Data' is source and
3rd tab 'Output' is the desired result