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

Hello there,

What did you want your results to look like?

Thanks for replying - Sorry, data I'm working with is person identifiable so can't attach it.

Basically I've got approx 4000 rows of dates of service contacts with patients and each
date has an identifier next to it - I've got approx 500 individuals in the data. What I
want in the results is a row of dates per patient so that I'll only have approx 500
unique rows with identifiers in column A and dates starting in column B and stretching
across columns as far as they need to for each individual.

Which is why I mocked up this really simole version of my data to share with you .....
Thought it might help!