Macro to autofill intermittent blank cells to the right

[alexcon]

Greetings can anyone please assist with a button macro to autofill cells to the right as per the colored-in cells in screen clip below:

https://ibb.co/ew2Sbb

Whenever the value changes, it fills to the right according to that value, then when a new value is found, it fills to the right according to the new value and so on.
If possible would also like it cope when more columns and rows are added later.

[Kaper]

Attach a sample workbook (not just picture). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window. Many forum users can't and/or do not want to open files from external servers