Forum Discussion
Solved
Selecting cells adjacent to empty cells.
So here is an example,
I want select the cells adjacent to empty cells (e.g Numbers which are in bold) and move them up to the third column on the side of the same number.
I have data in following format:
| A | 1 | |
| B | 2 | |
| 2 | ||
| C | 3 | |
| D | 4 | |
| 4 | ||
| E | 5 | |
| F | 6 | |
| 6 | ||
| G | 7 | |
| 7 | ||
| H | 8 |
I want the output in following format:
| A | 1 | |
| B | 2 | 2 |
| C | 3 | |
| D | 4 | 4 |
| E | 5 | |
| F | 6 | 6 |
| G | 7 | 7 |
| H | 8 |
Can anyone help since the data I have is much bigger near to 500 rows.
Thank you!
Attached is a sample file which returns the intended result with formulas that work in Excel 2013.
2 Replies
Attached is a sample file which returns the intended result with formulas that work in Excel 2013.
- Thanks you! It worked!
