rearranging pivot table

[Yuriy B]

Hello, I need assistance with rearranging PivotTable.

My Raw Data looks like this:

Batch # Material #
Batch 1 Material 1
Batch 1 Material 1
Batch 1 Material 1
Batch 1 Material 2
Batch 1 Material 2
Batch 2 Material 2
Batch 2 Material 3
Batch 2 Material 3
Batch 2 Material 4
Batch 3 Material 4
Batch 3 Material 4
Batch 3 Material 4
Batch 3 Material 5
Batch 3 Material 5
Batch 3 Material 5
Batch 3 Material 5
Batch 3 Material 6
Batch 4 Material 6
Batch 4 Material 6
Batch 4 Material 6
Batch 4 Material 6


PivotTable looks like this:

Row Labels
Batch 1
Material 1
Material 2
Batch 2
Material 2
Material 3
Material 4
Batch 3
Material 4
Material 5
Material 6
Batch 4
Material 6


I need my data to look like this:

Batch 1 Material 1 Material 2
Batch 2 Material 2 Material 3 Material 4
Batch 3 Material 4 Material 5 Material 6
Batch 4 Material 6

(Notice that Batches can share material)
I don't care if a PivotTable looks different or there is a formula that I can use on Raw data what will sort it differently.
Your help is appreciated.

 

[etaf]

what version of excel
look at Pivot table Menu on the ribbon
Design
report layout
choose
show in tabular form

see if that works for you

 

[Amanda Wilso]

Click the PivotTable report.
On the [FONT=wf_segoe-ui_semibold]Design[/FONT] tab
[FONT=wf_segoe-ui_semibold]Report Layout
Show in Tabular Form Use to see all data in a traditional table format and to easily copy cells to another worksheet.

You can rearrange existing fields or reposition those fields by using one of the four areas at the bottom of the layout section.
To rearrange fields, click the field name in one of the areas, and then select one of the commands
You can also click and hold a field name, and then drag the field between the field and layout sections, and between the different areas.[/FONT]

 

[Yuriy B]

I am using Excel 2013. The Tubular Form (or Outline Form) Gets me closer to what i am looking for. It is still not completely horizontal because it stacks the Material. Can I transform this using formulas in to completely horizontal data? Can I use a formula on the raw data that would do this for me and skip the Pivot table all together?