I have a dataset structured like the image attached. can you find a way to better formatting this data using Python Pandas? Ideally getting rid of all the leading NANs in each column. To explain, for each name (name1, name2, etc..) there are 3 corresponding columns associated with it (id, column_1, column_1). For the second name (name2), the corresponding three columns starts at row + 1 (row2), leaving the first row of these columns as NAN (needs to get rid of these NaNs). and this pattern continues in this dataset.

can you re-structure this data (maybe need to transpose it or something?)
Thank you!