Any chance you could structure the data a little differently? It would be best if you could separate the project leads out of the first table. So, you'd have one table with the project costs:
And another with the leads (one row per lead):
Then, in Tableau, you could join these together:
And the rest would be just to create a simple viz:
Attached is the Excel workbook and a packaged workbook.
Hi, just following up on this to see if we've addressed your question or you have additional questions. Please advise.
Hi Ken! Thanks for replying. We're trying for a quick solution that connects to an existing SharePoint list used by our business groups. Do you know if it is possible to connect multiple SharePoint lists to allow for data structuring as you suggested?
I don't have a lot of experience connecting to SharePoint but perhaps others here could answer that.