Outputting rows between key rows in column into one cell (while preserving formatting)

Hello,

I need to make a column of data on Sheet2 (although much longer), into two cells of data on Sheet1, based on several key rows, such as "jewelry" and "fruit", for example. I need to preserve the original formatting, and even better would be to retain the spacing instead of using commas to separate the combined text, although it seems it's not possible to have multiple lines of data in one excel row.

Thank you!

ML

This is part of the code I have so far:

Please Login or Register  to view this content.

The concatenate part of it works. But it doesn't retain the formatting. I've done some browsing, but all the codes I've seen about retaining format while concatenating appear to be way over my head.

Thanks for any input on how to retain the formatting.