split & transpose columns to rows?

HI,

Looking for some help please, I've been playing with formula to do this and I know I can copy, paste special, transpose. But wanted a quicker way to automate this process.

I've attached a simple worksheet, similar to that which I'm working on (the real thing has 4000 rows and apprx 20 columns!).

I need to produce the data in column B against each individual named in column A, I've used the simple IF function in column C to be able to produce a 'false' so I can establish where each range begins and ends as each range is different.

Thanks
T