TransWikia.com

I need a way to group or nest items within columns

Project Management Asked on November 8, 2021

I am trying to analyze a data set that has nested data. I have a column that contains projects, a column that contains activities of those projects, and dates that those activities were completed. I want a way to filter by projects, and then after that filter by the date of activity completion.

Here is an example of what I have (filtered by project):

Projects | Activities | Dates

Project #1 | Activity #3 | Date

Project #1 | Activity #1 | Date

Project #1 | Activity #2 | Date

Project #2 | Activity #2 | Date

Project #2 | Activity #3 | Date

Project #2 | Activity #1 | Date

Project #3 | Activity #3 | Date

Project #3 | Activity #2 | Date

Project #3 | Activity #1 | Date

Here is what I want to achieve (filter by project and activity):

Projects | Activities | Dates

Project #1 | Activity #1 | Date

Project #1 | Activity #2 | Date

Project #1 | Activity #3 | Date

Project #2 | Activity #1 | Date

Project #2 | Activity #2 | Date

Project #2 | Activity #3 | Date

Project #3 | Activity #1 | Date

Project #3 | Activity #2 | Date

Project #3 | Activity #3 | Date

I want to make a table that looks like this so I can design a column that shows the distance between the dates of the activities completed. I then want to use these distances to make a chart showing the average number of days between the activities. I feel as if I cannot do that without sorting with the method mentioned above. Can anyone point me in the right direction to accomplish what I am looking to do?

One Answer

Easy one. Just put your data into a spreadsheet software like Excel or Lotus Notes. Put a nice filter around your data then sort by date and then sort by project.

This way you have a list that is primarily sorted by project and secondarily by date ;)

Answered by user32793 on November 8, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP