kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 926
- Office Version
- 365
Hi,
I have the following raw data from an AS400 system:
Raw Data in Sheet 1
Each of the process type is categorized as follows:
Table 1 In Sheet 2
The above category does not exist in the raw data.
Would it be possible to summarize the raw data in a summary table in sheet 3 by referencing the raw data in sheet 1 to the category in sheet 2 ?
Summary Table in Sheet 3
I have the following raw data from an AS400 system:
Raw Data in Sheet 1
Each of the process type is categorized as follows:
Table 1 In Sheet 2
The above category does not exist in the raw data.
Would it be possible to summarize the raw data in a summary table in sheet 3 by referencing the raw data in sheet 1 to the category in sheet 2 ?
Summary Table in Sheet 3