Removing cells that are blank

[Teblol]

Hi All,

I have been working on something all day and I am now stuck at a spot. I need to list the results from column M into column AD, then below that I would like the results from column O to be listed below the results copied from M. I will need the results form column Q to follow, as well as the results from column S. I also need the headers to be listed above each break. I am trying to figure out a better way to explain this, but I am at a loss. Hopefully my attachment will help. I have manually listed what I want the results to look like in column AD.

EASY VA05 example.xlsm

Thanks everyone

[Teblol]

So I have figured out a way to do it, but now I cannot figure out the final step to remove the blanks. I have the formula in AO to remove the blanks from AM. There seems to be a problem due to the formula which doesn't make sense because I have basically the same formula in column Y which takes data from another cell that has a formula.If anyone can figure out a formula to put in column AO that will take away the blanks from column AM it would be greatly appreciated.

EASY VA05 New.xlsm

[azumi]

Maybe not perfect but try this...pls see the file attach

regards

[Teblol]

Hi Azumi,

Thanks for the reply. I have tried to make your formula work for my updated worksheet, however there are two issues. One being that I have added two new columns. Second being that the ranges don't appear to be dynamic. Each column could have up to 100 lines. This is my mistake since I was not clear about that. If you could please take a look at my new attachment and update the formula to meet the new criteria, or if you have a formula that will remove the blanks from column AX it would be appreciated. I am so close with the formula in AX, but the formula I use to remove blanks isn't working.

EASY VA05 New.xlsm

Thanks for your time.

[Teblol]

Looks like I keep solving my own problem. I came up with the below formula and it works perfectly. I am also attaching the workbook with the formula to show the solution.

Please Login or Register  to view this content.

EASY VA05 New.xlsm