1 row cell covering 4 rows, but the next column divided in separate rows

I am working with an excel spreadsheet that was given to me.

There is a column for "name", and then the next column is for medical condition.

If the same patient has multiple (say, 4) conditions, the rows for "name" are combined into a single cell(let's say, a cell going from row 2 to row 5, witha a single name in the combined cell) , with the next column having four different cells adjacent to the single cell (cell 2 has "bleeding", cell 3 has "fever", cell 4 has "diarrhea", and cell 5 has "rash"). Some patients have only single conditions, single cells.

Will this mess up my COUNTS and COUNTIF?

Is there a way to split the combined cell2-5 for ''name" into four cells all containing the same name?

is there any convenient way to unmerge the cells so that they all contain the same values?

Can you use text to columns in this case? I assume your categories are the same or are separated by comma, semicolons, hyphens?

Data -> Text to columns