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.

  • Hi Carson. Welcome to drupal.stackexchange! Could you include the version of Drupal you're using in your question via tag or title? Dec 6, 2012 at 19:39
  • Hi Carsonw, have you solved this? If so, how? Can you please inform us... I am overall in same situation
    – user12947
    Oct 16, 2013 at 10:11
  • No, I don't think it is possible.
    – carsonw
    Oct 16, 2013 at 16:22

1 Answer 1


Have you noticed the following setting on the field which has multiple values:

enter image description here

That should be a collapsed section right under where you specify the label, etc of your field. Just make sure you check that you want them to appear in the same row and select a separator (comma by default).

That should be all you need! Does it transfer well for the export?

  • Boriana, thank you very much for your answer. However, it doesn't fit my situation, and I updated my question above to better reflect what I'm dealing with. I'm not dealing with a content type with one field with multiple values. Thanks again.
    – carsonw
    Dec 6, 2012 at 21:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.