Transforming data into particular view

[Joy_23]

How to transfer this data with below view on Qlik dashboard?

[brunobertels]

Hi 

below the logic step by step  

1 : load data as it is 

2 : replicate field Region when missing

3 : croostable data 

4 create new fied for Globa et South named Type_Region and create subfield Type for A B C . 

: 

LOAD * INLINE
[
Region,Country,A_Global,B_Global,C_Global,A_South,B_South,C_South
Asia,India,12,42,12,10,9,8
,Srilanka,12,32,12,23,3,5
,Japan,12,1,43,23,22,12
](delimiter is ',');

NoConcatenate
Table1:
load
if(len(Region)>0,Region,peek('Region')) as Region,
Country , A_Global,B_Global,C_Global,A_South,B_South,C_South
resident Table; drop table Table;

Table2:
crosstable ( Type,Amount,2)
load* resident Table1; drop table Table1;

noconcatenate
Table3:
load
Region,
Country,
subfield(Type,'_',1) as Type,
subfield(Type,'_',2) as Type_Region,
Amount
resident Table2 ; drop table Table2;

Resulting Table : 

hope it helps