This is rather small project.
We get huge data sets that are scrubbed and populated into reports. Most of the data comes in sets that are 3500 rows and about 550 columns. We find ourselves moving manually a lot of this data aligning it to one specific column (deleting empty cells in rows while shifting data to the left to align ALL data sets). To clarify - no consolidation of data needed, but deleting empty rows while shifting data to the left (to align to a certain column).
Manually it takes a lot of effort. What we would like for someone to write a good VB code that can handle rather large data sets with clear instructions on how to implement this code.
For someone who knows VB we know it will take no time to create. We would like a support as well on helping us to implement it. Would prefer VB with a button which would allow "no-brainer" approach.