Jerry138889
New Member
- Joined
- May 23, 2013
- Messages
- 28
A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels.
I am trying to convert this data into data that is pivot table friendly.
I currently have data like this where Location is always filled out and will have at least one (but possibly more) entries but Shop Name and Employee might have blank/zero values or an actual value.
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I am trying to convert this data into data that is pivot table friendly.
I currently have data like this where Location is always filled out and will have at least one (but possibly more) entries but Shop Name and Employee might have blank/zero values or an actual value.
Location |
France |
Germany |
Shop Name |
Aldi |
Employee |
Sally |
Harry |
Peter |
Location |
France |
Shop Name |
Carrefour |
Employee |
Francis |
Petra |
Location |
USA |
Shop Name |
Walmart |
Location |
UK |
Shop Name |
Tesco |
Morrison's |
Employee |
Jerry And I want to convert it to this type of data so that I can manipulate it in a pivot table |
<colgroup><col></colgroup><tbody>
</tbody>
Location | Shop Name | Employee |
France | ||
Germany | Aldi | Sally |
Harry | ||
Peter | ||
France | Carrefour | Francis |
Petra | ||
USA | Walmart | |
UK | Tesco | |
Morrison's | Jerry |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>