nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Does anyone know a quick and easy way to convert a cross tab table into a flat table so I can analyse my data better in a pivot table?
Excel 2010 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Row | Column | Value | ||
2 | operator 1 | Air System | |||
3 | operator 1 | Air System | |||
4 | operator 1 | Air System | |||
5 | operator 1 | Assisting on other m/c | |||
6 | operator 1 | Assisting on other m/c | |||
7 | operator 1 | Assisting on other m/c | |||
8 | operator 1 | Changeover / Setting up | |||
Sheet4 |