Update column in Table 2 based on column value from Table 1

[jfsdropshipper222]

Hi All,

I have two tables. Table 1 contains Investor information and the funds they invested in.

Table 2 is the table I need to update depending on where the fund is invested in Table 1.

I'm been sitting on this for a few days now and I can't think of a way to update Table 2 using a join on column values from Table 1.

Thanks in advance.

Table 1

Investor	Investment Amount	Fund
A	200	1
B	100	4
C	300	5

Table 2 (Existing Table)

Investor	Investment	Fund 1	Fund 2	Fund 3	Fund 4	Fund 5
A	200	200	0	0	0	0
B	100	0	0	0	100	0
C	300	0	0	0	0	300

Unfortunately, I cannot attach anything as Alteryx is tagging my account as spam.