Transposing various columns and rows into one sheet

Hello all,

i am in the middle of writing a macro and have come a bit stuck with what to do next.

i need to take the data from column B-CE and transpose it into one sheet as rows.

which i can do fine, the problem i have is that the info in column A is a unique identifer. below is an example

person 1, a b c d e f g etc
person 2, a b c d e f g
person 3 a b c d e f g etc

i need to be able to transpose, but also keep the unique identifier with it and change it into columns.

for example

person 1 a
person 1 b
person 1 c
etc
person 2 a
person 2 b

the results, or scores, will be different each time,

and so on, i think its something like 1805 rows

i need the info to also be transposed into a different sheet which i can then upload into a new HR system.

i've been writing in VBA but i'm getting stuck in getting it to "goto" the next line, as in, copy from X and paste, now do the next line.

i'm assuming that i need to use a macro as i've tried OFFSET and had no luck.

can anyone help please to save me a couple of weeks of pressing ctrl+C ctrl+V?

I've looked all over the forum and can find close to what i need but whilst im good with excel, VBA is a whole new ball game.

many thanks....