How do I layer info in Excel. Have large amts of data to sort.

S

Sally

Creating spreadsheet. Have large amts of data. For example, could have 937
names under one name, then 609 names under that 937 will have several layers
of info with it.
Ex. Column with "Person1". Under "Person1" I have 937 "Persons2". Under
each of the "Persons2" several data like dates, Y/N, location, training
scheduled, etc.
More of a "layering" technique.
Any help is appreciated!
 
P

Pete_UK

Think about aranging your data going across columns, so you have your
Person1 column (eg for a manager?), and that first name is repeated in
937 rows. Against each of those entries you would have columns for
Person2, date, y/n, location etc. Then the next block of data would
have a different name for Person1, and his/her subsidiary data in the
adjacent columns.

Hope this helps.

Pete
 
Top