Condense multiple rows into a table view

Hi,

I currently have a spreadsheet that contains a list of new joiners to my company with any outstanding tasks that need to be completed before they can join. This contains any person who has joined the firm up to 30 days in the past all the way to those joining 90 days in the future.

Each outstanding task has it's own row, so each Joiner can have several rows, depending on what is outstanding (if a task is completed it will not appear in the view.) The spreadsheet currently stands at about 6000 rows but this can vary somewhat (up to about 8000.)

What I want to do is to produce a summary view that will show a table with Joiners names on the rows and every possible task in the columns, then to show all of the names that are joining the company in a given period (most likely five days) along with flags to show which tasks have been completed or not.

I imagine I will need some kind of array formula to get this to work but I'm a little out of practise, if someone could get me started that would be a great help.

Any questions let me know

Thanks

Jon

Hi!

Wouldnt it be easier to use a pivot table per user for this?

Hi,

Thanks for coming back to me!

In this case, no, one of the main points of the table would be that it returns the names of the people based on the date range required. Each week there can be 30 or more people joining and we wouldn't know these names prior to inserting the raw data.

Thanks

Jon

You can solve the problem of variable list length using dynamic ranges as table for a PT