Is there a formula I can use to format data? I have a spreadsheet that is
saved from a database but the data ends up in different columns and I have to
fiddle with it to align everything just right. For example on piece of data
will be in cell a1, the next piece will be in b2, then b4, then c3 and c5.
Is there a code that will remove empty cells?