I have a design question for you gurus.  I'm fairly new to CR - I've taken the first course at BO's website.  I have pulled the data I need, but I need some help formatting it.

The data is a list of subscriptions.  There is one line per subscription - but there are multiple lines per subscriber.  What I need to do is change the format of the final output so that it reads as follows:

subscriber1    subscription1     subscription2    subscription3    subscription4    etc
subscriber2    subscription1     subscription2    subscription3    subscription4    etc

Can I get an assist on how to do this?

The current format is as follows:

subscriber1     subscription1
subscriber1     subscription2
subscriber1     subscription3
subscriber1     subscription4
subscriber2     subscription1
subscriber2     subscription2
subscriber2     subscription3
subscriber2     subscription4

Thank you,

Sean


Edited by SeanRinVA - 10 Dec 2007 at 10:11am