I have a weird report request, I don't think I can accommodate the requester but thought I would ask the experts. If I'm not being clear with my question, please let me know.
I successfully created a report in Crystal Reports 11 which includes, among other things, customer id, customer last name, customer first name, customer phone number, customer balance, then lists customer contacts (1 thru 9) and a few more fields after that. There are multiple tables involved. The resulting report shows the correct information however the requester wants to see the customer contacts (1 thru 9) individually in a separate column for each and not in a list (or vertically down) as displayed. There is no identifier in that table for each contact per customer, only a sequential id for the entire system. Meaning, I can't see a way to report column 6 with contacts from slot a, column 7 with contacts from slot b, and so on up to 9 contacts. I tried a crosstab but that didn't work either. I then copied the contacts field 8 times and tried process of elimination for each column with Selection Expert but since the contacts are all in one table it affects all contact columns equally.
I found info to convert rows to columns but not the other way around.
This particular report is being imported to another application and that is why the requester needs the report in columns. I don't think I can do it but want to exhaust all options before telling the boss 'no'.
Is there a way to list multiple bits of info from one field in a table separately across columns?
Thanks for any input.

Thanks for your reply bwsanders, the customer contact field is a phone number and there can be up to 9 customer contact phone numbers per customer. I can do simple formulas but am not all that versed in complex ones so wouldn't know how to go about it.

Thanks again bwsanders, that didn't work but it did make me think of something else
(sorry for the emoticon, if it's showing up, I clicked when I shouldn't have and now can't get rid of it)