How to Fix: Columns containing erroneous row data

[stexcel123]

As you can see, there is erroneous row data under various columns, namely, brand, services and products. I am trying to organize this data in a way so that each row of information matches the column header. I know there might be solutions using VBA Macros or Countif formulas based on another thread and I've tried both but keep outputting wonky formatting errors. Please assist. Thank you. (I am not able to post URLs etc until I post a couple of times, please dm me your email for workbook or if you know a workaround)

[Pete_UK]

Even if you have only made one post, you should still be able to attach a workbook to your posts.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do NOT try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete