That worked great! Thank you so much for your response!!

"Debra Dalgleish" wrote:

To reorganize the data, you can use the 'unpivot' technique described by
John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm

Before you start, change the Dept headings to numbers, or after you
unpivot you can use EditReplace to remove Dept from the Dept column.


Viv wrote:
I have a spreadsheet similar to this which shows access right for several
depts:

Account Dept 1 Dept 2 Dept 3 Dept 4
Salaries READ READ READ READ
Supplies WRITE READ WRITE WRITE
DEPREC READ READ READ READ

I want to end up with:

Account Dept Access
Salaries 1 READ
Salaries 2 READ
Salaries 3 READ
Salaries 4 READ
Supplies 1 WRITE
Supplies 1 READ
Supplies 1 WRITE
Supplies 1 WRITE


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html