Database Setup
 

I have a setup of rows that contain details for each tenant with in
property.

A list of data as an example:

Ten 1 | Prop 1 | Note
Ten 2 | Prop 2 | Note
Ten 3 | Prop 1 | Note
Ten 4 | Prop 1 | Note
Ten 5 | Prop 2 | Note

Now I can sort the data with the built in function sort so flow Prop 1
Prop 2 etc. But I want to be able to create another tab which will be
"presentation quality" and have headers spliting up each of th
properties.

like:

Prop 1
Ten 1 | Note | Calc
Ten 3 | Note | Calc
Ten 4 | Note | Calc

Prop 2
Ten 2 | Note | Calc
Ten 5 | Note | Calc

Like a pivottable really if you know what I mean!?

Any one out there done anything similiar to this?

Thanks
Simo

--
Message posted from http://www.ExcelForum.com