I'm not an advanced excel user but I have a query about it. I have a set of values in cells column B and there are random empty cells between one value in column B to the next value in a cell in column B. What I'd like to do is for every value present in a cell in column B say B1, I'd like to merge H2 and H3, two two further cells in column H into a cell G1 and delete the contents of H2 and H3. How can I use a formula to do this? P.S, I need to do this for about 50 pages in an excel document. Thanks.
use a formula in col G along the lines of
then, after checking the values in G are correct, copy the Column and paste values; then delete col H