Formatting semi-structure data using numpy in python

Question

I have generated the output using pandas. But, the same need to be implemented using numpy. The purpose to use numpy is it have more dynamic. Can any one please help me on implementing in numpy.

I have read the excel file and converted in to array using df = np.array(df)

1. Need to remove the nan value from excel
2. Need to format the rows in to column for Project

Input file:

Output File:

Need to do in NUMPY