I need some help in transferring data. I have data that is input on worksheet, pulled into another worksheet by sorting it meeting certain parameters, using IF functions. However, I need to concatenate it to a third worksheet into groups, deleting the blank cells. I have used the CONCATENATE, but need to eliminate the blank rows, otherwise the cell I am transferring the data to is huge. Here is an example:
Apple
Banana
Grapes
Kiwi
Pear
However, this data might change month to month. I want to combine this information into one cell to look like, while eliminating blank cells that might appear before, after or inbetween the items in the listing:
Apple
Banana
Grapes
Kiwi
Pear
I have no programming skills and would be at a loss using VB.
Bookmarks