Macro To Recognize Content Between Two Fixed Values And Transpose To Columns?

I have a long (190,000) list of customer data, all in Column A (unfortunately with blank rows among it, but working now to fix that).

Down the column, individual customers are bookended by a "adf" and a "/adf". (these have open and close brackets like HTML code, but I cannot reproduce them in this forum).

For each customer, I need to find the rows that begin with (brackets spelled out since I do not know how to show them):

1. [open bracket] vehicle status

2. name part=3D"first"[close bracket]

3. [open bracket]name part=3D"last"[close bracket]

4. [open bracket]email[close bracket]

5.[open bracket]phone time=3D

6.[open bracket] name part=3D

And transpose only those rows it into columns.There is a dynamic number of rows for each customer, so there's no way to simply count and transpose, as the columns would all be mis-entered.Somehow it needs to recognize those 6 row items, and transpose those values only, with the and the only telltale of a start and finish of a specific customer.

EDIT: How about a macro to delete all rows except those that contain those partial values above?