How to apply multiple formatting in same cell for concatenated values

Hi there.

Complete newbie here and very much struggling.

Need to concatenate the values of two columns in a newly created column. I need the values (text strings) to be on their own separate lines w/in the same cell. Additionally -- and here's where I'm super confused -- I need each row to be formatted differently.

In the concatenated column (Column B), I need the top row (string from Column C) to have Calibri, Size 9, Bold, #4472C4 font. The bottom row (string from Column D) needs Calibri, Size 11 font.

Basically, I'm pasting a cluster of cells from another Excel file into a new worksheet and organizing/formatting the cells in a certain style. I've been doing this manually, but seeing as some of these worksheets are hundreds of rows long, I'd like to learn how to automate this process.

I've searched the forums here and I have seen that others have asked very similar questions and some lovely folks have provided snippets of code to add to macros. However, I am super super new to this world of macros (just realized their existed literally three days ago lol) and whenever I try to insert these snippets in the code, I obviously do it wrong and I get error messages and can't run the macro. I also can't figure out what I'm doing wrong.

I can't tell if I want an event macro, or the ability to click on a button/press shortcut keys and have the macro run. I think I'd like the latter option.

I've attached a sample excel file showing my attempt at concatenation, which I hope is helpful in illustrating my situation.

Thank you for any help you could spare.

Please forgive my ignorance ... but what does the "Next x" line mean? Also, where should I add this in the code?

thanks.