Two filters to select values and paste unique in another sheet

[xceptional88]

I have data as below

Currency Location
CAD 00002
CAD 00004
CAD 00005
CAD 00002
USD 00001
USD 00002
CAD 00006
CAD 00004
CAD 00005
USD 00001

I want to filter for CAD, then select the Location values and paste the unique values into a row on column I (starting I2) on CAD sheet.

Then again come to the same sheet, filter for USD and take the values and paste the unique values in column I (startingI2) on USD sheet.

I used one or few methods but it did not work for both for me and also copies the first as header but I do not want that.

 

[xceptional88]

In next step it has grown a little more complex

I have data

Currency Location Center Amount
CAD 00001 A0000 10
CAD 00002 A0000 20
CAD 00001 B0000 15
CAD 00004 A0000 10
CAD 00001 A0000 20
USD 00001 A0000 10
USD 00006 B0000 20
USD 00002 C0000 10

I want to have amount of each center by location and currency

What I was doing was filter CAD, identify unique values in Location and put them in one sheet in column so and then vlookup pivot to get the amount.

Now I what I want to do is have CAD filtered and take unique combination of location and center and then vlookup amount from the table. I know the part to lookup from the table using match/index comibination to identify row/column and lookup for the amount. But how do i identify different combinations.

on one sheet CAD i want below information
Location Center
00001 A0000
00001 B0000
00002 A0000
00004 A0000

Please help