Column A is blank, Columns B-E have data that is scattered (with blanks). I Need the formula to look in B-E and the first cell it finds that has data it takes and puts it in A. So in the end all data with be in column A and no data in B-E. Therefore, there is no stacking involved and the row does not change that the data is on, only the column changes (all data will be in column A).
Current Data
A B C D E
1
2
1
3
2
4
2
End Result
A B C D E
1
2
1
3
2
4
2
Bookmarks