Consolidate Excel Sheet into single and proper format

[santoshkumar5678]

Hello Team,

I have a question regarding the excel formatting one as I'm unable to do it with some functions and it is taking more time as I need to do manually. I have converted the PDF to Excel through (ILOVEPDF.com) and it worked properly but data was divided into spreadsheets as per the pages. So, please find the below questions

1. Entire data need to be in a single sheet and unnecessary data need to be deleted from all the pages like header and footer.

2. As per the document, it got converted into separate cells, but the data need to be in a single row. Example in the page #34 (U.S. Treasury Inflation-Indexed Bonds 3.625% 4/15/28) got separated in to 2 row cells and also for the security (BX Trust floater, sequential payer Series 2019-XL Class A, 1 month U.S. LIBOR + 0.920% 1.0948% 10/15/36) it got separated into 3 rows cells. But it should consolidate into single row and at the same time information related to it aligned in that row only.

For your reference purpose I've attached PDF & Spreadsheet (Manually converted till 33th Page). So, could please go through the above and do the needful.

Thanks in advance.

Santosh.G