Group by and Transpose in Query?

Hi all,

I'm not really familiar with the use of Queries in Excel 2016 but my attempts to get the required result by Merge and or Transpose did not succeed.

This is data in the source_table

T1.jpg

What I need is a new table with
- 1 row per CODE (1st column)
- 1 column per CI_LOC with data from My Cust No per CODE

The result should look like this:

T2.jpg

I know how to get this done by using a Pivot but would like to create a new Table instead.

Can anybody tell me what I should do?

* attached is the data in excelfile