How to convert data in excel from one column into multiple rows

I have extracted data from website table into excel file and it came into one column, as data is present in row wise table so we could not use web loop table .
I want to convert this data from one column into 4 rows ( as per contain ) so that it will come as complete table format.

You can use Row Normaliser and De-normalizer steps in this scenario.