show pivot table detail in same cell

N

njoy

I would like to create a report using following sample data in excel

ticket , monthly release ,
application
111-fix login bug , 2006-06 , ABC
112-improve logging , 2006-06 , ABC
113-enhance blah blah , 2006-07 , XYZ
114-fix performance issue , 2006-08 , ABC
115-implement cash app , 2006-08 , XYZ


using this data I would like to create following report (application
roadmap)
i.e. which ticket would be implemented in which monthly release

application 2006-06 2006-07
2006-08
ABC 111-fix login bug
114-fix performance issue
112-improve logging
XYZ 113-enhance blah blah
115-implement cash app
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table question for Excel gurus .. seems difficult. 1
Row totals Calculations in Pivot Table 0
Row totals Calculations in Pivot Table 0
Modifying Ron's Sub Copy_To_Workbooks 2
multiple ranking (sorting), based on diff. criteria 0
Powerpoint Crashes when started 0
Office applications crash on launch 5
Problem opening Word for Mac in Imac 0

Top