Dynamic Index/Matching

[SWobig]

Hello and thank you for looking! I need help with the below spreadsheet that is over 1100 lines long. I need to be able to organize this data to see name (8th column over) going down, G/L code (2nd column over, but there are 21's listed in that column as well that have no effect) across the top and a sum of all amounts in the last column.

SW MC JS CS WT JW
1999 $16,1665.92 $1461.36 $2664.59 $812.01 $1312.75 $2609.53
2140 $1119.56
2215 etc, etc. and so on...

Report selections:		G/L code:	ALL				Company code:	ALL	Employee code:	ALL	From G/L date:
G/L code:	1999		Cost Center Interpost
01/17/21	21	04	112	250984	M	WO	SW	01/22/21	01/17/21		16,165.92
01/31/21	21	04	112	250988	M	CU	MC	02/05/21	01/31/21		332.14
01/31/21	21	04	112	250991	M	CU	MC	02/05/21	01/31/21		1,129.22
01/31/21	21	04	112	E28477	R	ST	JS	02/05/21	01/31/21		2,264.59
01/31/21	21	04	112	E28480	R	SU	CS	02/05/21	01/31/21		812.01
01/31/21	21	04	112	E28490	R	TR	WT	02/05/21	01/31/21		1,312.75
01/31/21	21	04	112	E28511	R	WI	JW	02/05/21	01/31/21		2,609.53
						Subtotal for G/L code: 1999			0.00	447,090.24
G/L code:	2140		Accrued Payroll
01/03/21	21	04	112	E26957	R	TR	WT	01/08/21	01/03/21	895.64
01/10/21	21	04	112	E27363	R	TR	WT	01/15/21	01/10/21	223.92
						Subtotal for G/L code: 2140			1,119.56	0.00
G/L code:	2215		Accrued Holiday & Vacation
01/03/21	21	04	112	E26764	R	AL	TA	01/08/21	01/03/21	377.76
01/03/21	21	04	112	E26767	R	BA	RB	01/08/21	01/03/21	358.19
01/03/21	21	04	112	E26782	R	BU	SB	01/08/21	01/03/21	377.76
01/03/21	21	04	112	E26788	R	CA	JC	01/08/21	01/03/21	368.02

 

[SWobig]

What it returns should look something like the below. I can't get the plugin to work, ugh

	SW	MC	JS	CS	WT	JW	TA	BA	SB	JC
1999	$16,166.92	$1,461.36	$2,664.59	$812.01	$1,312.75	$2,609.53
2140					$1,119.56
2215							$377.76	$358.19​	$377.76​	$368.02​
etc, etc