Auto re-sizing a merged cell based off a dynamic search?

Hi guys,

I've got a merged cell (A9) that pulls in information from a V-lookup from the search box selection in 'Job Title' cell. The data gets routed to cell A9 and it varies from 2 lines to 8 lines of information. Currently, I have cell A9 set up to be able to contain enough space for 8 lines of data roughly.

Is it possible to write some code or format cell A9 such that the size of the cell automatically adjusts the row height to the size of the information that is bringing brought in?

Want: I.E. if the user selects an entry that returns 2 lines of data, I want the cell to shrink to match to fit 2 lines of data. Vica versa, if the v-lookup returns 8 lines of data, I want the cell to expand to match to fit those 8 lines of data.

Is this possible?

I'm attaching a picture to show how awkward cell A9 is when it only returns 2 lines of data - so much empty space below the data.