need help to clean data where column runs uneven

[dabblerc]

hi i have a report where the data spills across columns unevenly.

e.g. the

Details field on

row 2 should be "FerrarriRedHot",

row 3 should be "BrandNew",

row 4 should be "WonInLuckyDraw"


for some reason when i get the data, it spills across column unevenly and the only way i can identify is by keywords for the column Status e.g. Ok. So what i am currently doing right now is

1) create a new column on the left to Details

2) sort the columns on the rightmost after MoreDetails

3) use a string concatenate the "House"&"End"&"Of"&"The"&"Road"

4) repeat to sort the next column, repeat to concatenate the string

5) delete the columns to bring Ok under Status


just wondering if there is a shorter way to do this with VBA or macro? Am afraid my VBA skills is very rudimentary IF this is the wrong place to ask, can please help to point me to the right place, as am afraid the company doesn't permit installation of foreign software or open source data cleaning softwares in cases of ransomware

i attach the image of how the file looks like here
https://imgur.com/a/aaKRz

 

[AlanSidman]

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.