I have spreadsheet with the data set up like the first table. It runs across for 100's of columns, these are just the first 3 categories. Is there a way to pull the amounts based on the location and acct# in a set up like the second table? All of the Acct#'s in the data are not the same in each row as shown in the 4th row. Thanks for any assistance.
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1874[/TD]
[TD]291.25[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1874[/TD]
[TD]300.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1874[/TD]
[TD]225.50[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1875[/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1875[/TD]
[TD]200.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1875[/TD]
[TD]25.00[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1876[/TD]
[TD]50.50[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1890[/TD]
[TD]80.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1880[/TD]
[TD]75.50[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1874[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1875[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1876[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Atrium[/TD]
[TD]1874[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1875[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1890[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Location[/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1874[/TD]
[TD]291.25[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1874[/TD]
[TD]300.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1874[/TD]
[TD]225.50[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1875[/TD]
[TD]100.00[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1875[/TD]
[TD]200.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1875[/TD]
[TD]25.00[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1876[/TD]
[TD]50.50[/TD]
[TD][/TD]
[TD]Land[/TD]
[TD]1890[/TD]
[TD]80.00[/TD]
[TD][/TD]
[TD]Atrium[/TD]
[TD]1880[/TD]
[TD]75.50[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]Acct#[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Reno[/TD]
[TD]1874[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1875[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1876[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Atrium[/TD]
[TD]1874[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1875[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1890[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]