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.
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.