I get a raw data dump from another system and it generates a single cell of data, per column, which can appear anywhere starting in row 2 through row 200. I need a code that will start in column A and look at all cells starting in row 2 through row 200. Once a cell is identified that contains text, cut that cell and bring it up to row 2. Then do the same for each column following through column BT.
I've attached a smaller version of my report which can be used for an example. Sheet1 contains the before and Sheet 2 contains how it should look once this code is ran.