Hi,

I have a list of patients. Each patient has at least 2 scores (each in their own cell) in a row next to the patient ID. They can also have more scores listed below this row but all the scores are in the same collumn.

For example:
A1: pt 1 A2: score 1 A3: score 2

It can also be (more commonly):

A1: pt 1 A2: score 1a A3: score 2a
B1: --- B2: score 1b B3: score 2b
etc.

I need these scores listed in rows next to the patient.

Using the second example, I need it to be like this:

A1: pt 1 A2: score 1a A3: score 2a A4: score 1b A5: score 2b

It is important to note that each patient can have a variable number of rows with scores below their ID. So one patient might need to have 10 new cells (5 sets of scores) listed in their row. How would I do this?

Thanks for your help