!!!NEED HELP TO GET THE ERROR OUT on Unpivot Multiple Selected Column.

[Chanleakna123]

HI EVERYONE , 

I stuck for 2 days with these 2 files now. 😞

My file got error with unpivot columns and look like i haven't found any result on it yet. 

when i unpivot it always get error on few columns which is hard for me find the solution . and one more on my date column , can you help to restructure on it . i can't transform it to Date Table. 

and below : 

here is the sample i want my table looks like :

https://drive.google.com/file/d/1mPh8GjFnIHiMuMgaGE_yJniloj1RdO76/view?usp=sharing

here are the source i have to make it look like the table i shared . 

1st Source : 

https://docs.google.com/spreadsheets/d/e/2PACX-1vQGwLNNPqXIrMNiEsL06MA2QDR6XPg0huxYPv-JcEx3kxwg8J1CG...

2nd Source : 

https://docs.google.com/spreadsheets/d/e/2PACX-1vRUd_mWMgZ2UyFsRjbiAkgm3SkfEcpv4_QZ3LglnOwTXoUKcp7pQ...

This will be a very big help for me to visisualize the reports into the organization. 

thanks with Regards, 
Chanleakna Hang

[Anonymous]

Not sure what you are looking for. It appears your source 1 and source 2 files already look like the table you want it to look like. Or am I missing anything?

[Chanleakna123]

hi ,  it doesn't , on source , there're a lots of columns together which is duplicated columns , the excel file is what ii want my table looks like. 

i show the orginated columns and tranforming table as the bottom.