Table help?

[Lori]

I have a spreadsheet that lists a risk, profile, department, and exists
(Yes/No field). This sheet lists every risk and profile combination and
whether the profile has the risk. The department field indicates who owns
the risk.

An example row in the table:

View Client (risk) Account (profile) Accounting (department) Yes (exists)

I need to make a spreadsheet where the output lists the each risks once down
the rows and lists the profiles across the columns once and then updates each
cell with Yes or No data from the Exists field.

Is this possible?

 

[AltaEgo]

Sounds like you need a pivot table. For the information you may need to
create a pivot see:

http://www.contextures.com/tiptech.html

 

[Shane Devenshire]

Hi Lori,

What you need is probably a pivot table.

How you do that depends on the your version.

Cheers,
Shane Devenshire