Converting varying length Vertically-aligned records to Horizontal Rows of list (tabular)

I have a Excel Spreadsheet with Records of books. The fields and data
value is entered as the First and Second Column (ColA, ColB). The
records are separated by 2 empty rows. Some fields are missing for
some records: Some record may miss the 'author' whereas some records
may miss some other fields, say ,'subject' AND 'totalpage'.

The Objective is to tranform the record horizontally with Each ffield
in one column with missing field blanked so that all the field are
aligned in a column e.g. colA for 'Title', colB for 'Author'


How can we convert varying length Vertically-aligned records (Figure
1) to Horizontal Rows of list (tabular) (Figure 2)

(Figure 1- Three records: varying length- subject & totalpage missing)
==================================================
Title Intro to Cpt
Author James, Page
publisher M-HILL
subject CPT
totalpage 311
isbn 123

Title Basic A/C
Author Ben William
publisher JWS
isbn 721


Title Modern Phy
publisher P-HALL
subject PHY
totalpage 466
isbn 265


(Figure 2: One Header of field name and all the records list
horizontally)
============================================
Title Author publisher subject totalpage isbn
Intro to Cpt James, Page M-HILL CPT 311 123
Basic A/C Ben William JWS 721
Modern Phy P-HALL PHY 466 265


Thank in advance