Design, Display & Layout Data Questions

A

Anony

Hi guys,

I have some questions on how to design, display and layout data.
Below is the background info...

i have 4 columns headers:
i) Name ii) SSN iii) Servers Hostnames iv) Access Rights

My question is how should i formulate or display my data if for 1 user there
might be alot of servers that the user have access to?

Any suggestions are appreciated.

Thanks in advance.
 
D

Dave Peterson

I'd keep each record on a separate row.

You can always sort your data by any of the columns later.

And excel offers a nice way to see just what you want.

Select A:D (headers in row 1 only)
data|filter|autofilter

Use the dropdown to show/hide what you want.

(data|filter|show all is a quick way of seeing everything again)
 
Top