Hi-
I have a macro that does some formatting to a spreadsheet - at the end of this macro, I'd like it to consolidate values into a single column and then delete one of the columns.
Here is an example of what it looks like
Before (what I have now)
A B 123 -- 456 456 -- 789 012 012
After (what I want after the macro runs)
A 123 456 789 012
There is some rows that have Headers that need to be skipped.
Bookmarks