Export formatted to show Multiple gifts vertically instead of horizontally?

Sarah Bodem

So i'm trying to export a list of constituents who gave multiple gifts throughout the year.  when i export it though, each gift has a column that goes horizontally across the spreadsheet into column HH.  is there any way to change this? For example, this is what i'm looking for:


ABC Company

1/1/17 $250

2/1/17 $55

3/1/17 $175


 

JoAnn Strommen

Transposing the rows/columns would get you close.  Assuming name date and amounts are all columns. You'd end up with

ABC Co

1/1/17

$250

2/1/17

$55

3/1/17

$175


You can google how to transpose if it's new to you. (Easier than my explaining.) Here's one link: https://www.techrepublic.com/blog/microsoft-office/transpose-excel-data-from-rows-to-columns-or-vice-versa/

Joshua Bekerman bCLO bCRE

Use a Gift export instead.  The donor name will be listed on each line for each of their gifts, but that can probably be cleaned up in Excel.

Tammie Cach Abdu

Sarah Bodem:

So i'm trying to export a list of constituents who gave multiple gifts throughout the year.  when i export it though, each gift has a column that goes horizontally across the spreadsheet into column HH.  is there any way to change this? For example, this is what i'm looking for:


ABC Company

1/1/17 $250

2/1/17 $55

3/1/17 $175


 

Have you tried building it out in Crystal?

Forrest Smith

Sarah Bodem:

So i'm trying to export a list of constituents who gave multiple gifts throughout the year.  when i export it though, each gift has a column that goes horizontally across the spreadsheet into column HH.  is there any way to change this? For example, this is what i'm looking for:


ABC Company

1/1/17 $250

2/1/17 $55

3/1/17 $175


 

To get exactly your format of result you mention in your question, I'd have to use Crystal.

Sarah Bodem

Joshua Bekerman bCLO,:

Use a Gift export instead.  The donor name will be listed on each line for each of their gifts, but that can probably be cleaned up in Excel.

The Gift Export worked out really well! I always forget that there is a difference between the types of queries/exports, i.e. Gift, Constituent, etc.  Thank you so much Joshua!