I'm using Drupal 7
I have a view displaying users that are referenced by another entity that has a date field, like this:
John Doe 5/6/12
John Doe 5/8/12
John Doe 5/16/12
Mary Jane 5/5/12
Mary Jane 5/7/12
So, behind the scenes, there's a content type of "Reservation" with a date field and a user reference field. I'm pulling in all of these reservations and displaying the user name alongside the dates of their reservations.
When I use the views_data_export module, I'm able to export this data as an xls file, which allows this data to open nicely in MS Excel.
The solution I'm looking for is to be able to group this data by user, to create unique rows with multiple columns, like this:
John Doe 5/6/12 5/8/12 5/16/12
Mary Jane 5/5/12 5/7/12
So, if a user has 20 pieces of data, then 20 columns will display next to that user with each column displaying each piece of data.