Consolidate a list of tasks from multiple tabs into one tab

[Stephen Gilchrist]

Hello,

I have three tabs that each list a number of tasks that need to be completed. I would like to create a summary tab that lists all of the combined tasks (backlog) in one sheet. These tasks are text. I cannot use macros since the sharepoint file will not support this function. Can anyone suggest a way to populate these tasks into one sheet? I would also like it to auto populate as I update the tasks.

For example,

Finance Tab

Task A 

Task B

Task C

Accounting Tab

Task D

Task E

Task F

Desired Result:

Summary Tab

Task A (finance)

Task B (finance)

Task C (finance)

Task D (accounting)

Task E (accounting)

Task F (accounting)

[#2 · Accepted solution]

Stephen,

You have a choice to use PowerQuery to do that!

Watch this video to learn how.

[#3]

This is exactly what I was looking for, thank you! The video was very easy to follow and gave me the outcome I desired.