Excel, How to extract records that are all in one column

How can I extract all the records stacked into a single column? I have many records of data that are stacked into (actually) two columns. Col. A contains field name, Col B contains the field value. Some of the records don't have all the fields, i.e., rows 2,3,4,5 contain values for 1st record; rows 6,7,8 values for 2nd record. Thanks.