I have a data in the following format in excel spreadsheet.
Actually the PatientID treatment and Test are given in merged cells.
For example for screening(value is 10) the data is available in the next row.
but PatientID treatment and test are common for first and second rows.
there are a variety of tedious but possible ways to read in such abnormally presented data, but my gut feeling is that you will be much better off if you can clean up the data from your source Excel spreadsheet to eliminate this kind of abnormality.