moving data across formula
Posted on 2016-08-26
I have a batch of data, and in columns A-E, are address fields, (address 1, address 2, address 3, address 4, zip).
In some cases, address 1 is empty, and the application has for some reason stared the addresses in address 2. What I need is a formula to basically say - if column A is blank, move everything from column B-F over a cell so all records start in column A. If column A is not blank, take no action.