Pivot table? or other solution

[lai0310]

I am trying to use a pivot table to arrange data in a specific order, but maybe a pivot table is not the best way to do this?

I have columns of data labeled: Problem, Solution, Category, Sub Category. (Very basic sample file attached).

Now I would like to create a pivot table that lists by category and sub category, all the issues and then all the solutions. But my pivot table gives me the information in the order of issue then solution, issue then solution. Maybe a pivot table is not the way to do this? I would like the results to look like this:

Payroll

Timecard Issues

Managers do not sign timecards.
Timecards are incomplete.

Management should sign TC's
Pre-fill tc's with ee names
​

Seems like odd format, but the truth is I copy this into a letter in Word, and include all of the issues one paragraph, and discuss of all the solutions in the next paragraph. My real table has up to 10 categories and up to 100 rows of issues, so getting the data into the proper order BEFORE I copy into Word would save me hours of cutting and pasting.

Thank you!

Any advice you can give me would be appreciated.

 

[Xiq]

Hi lai0310,

Here is a possible solution (see attached file).

 

[Aurelie]

Hi,

Another possible solution would be to display the pivot table in tabular form. To do this, go in pivot table tools in the ribbon, Design tab, option Report Layout and select Show in Tabular Form. See file attached.

Does it help?

 

[Somendra Misra]

Hi ,

See the attached, if tis meet your criteria. I had change the layout of pivot as table.

Is this what you want?

Somendra.

 

[lai0310]

Hi ,

See the attached, if tis meet your criteria. I had change the layout of pivot as table.

Is this what you want?

Somendra.

The problem is that puts the issue and solutions side by side, and I am trying to be able to copy and past them into a letter in Word, which is why I am trying to get all the issues first, with all the solutions underneath ... i.e. issues in paragraph 1, then solutions in paragraph 2.

 

[Xiq]

Hi lai0310,

Have you looked at the file I posted?