Macro to delete certain rows and create columns

Hello,
I have this spreadsheet containing imported data from an application. I want to delete every row that doesnt start _Variable and convert into column the commas.

the spreadsheet is attached.

thanks for your help.