Concatenate a variable # of cells based on 1 criteria into a cell then autofit the text

Hello everyone,

Using the screenshot example below, I want to create a macro to concatenate the values (starting in row 4) for columns A & C (with ". " in between and a line break at the end of each) based on ANY value in column B (Status) and put that concatenated text in cell C2 in a format like the example below (but stopping after Test Description 7 in this example).

Also, if possible, I would like to automatically expand or contract the height of Row 2 to fit the contents of C2.
Concatenate.jpg

I appreciate any help with this and thank you in advance.

Please Login or Register  to view this content.

Thanks Walruseggman! That got all of the rows concatenated just as I wanted.

However, I forgot to include in my original description that I would like the first sentence ("The following tests were successfully completed for PCR 97456:") added at the beginning. How would I properly do that?

Please Login or Register  to view this content.

Thanks so much, that did the trick!

However (again, sorry) C2 is merged together with D2 so the AutoFit doesn't work properly. Is there anything I can do to remedy this without un-merging the two cells?