I have a list in Tableau in with Area, Tasks and task owner as three columns.
All of them are strings, for example if in area Z there are 3 tasks A B C in separate rows and Task owner is for A B C is 1 2 2 but the middle 2 is missing from data how do I copy the 2 from the final row to the middle row.
I can't share the data as I don't have permission to share.
Thanks
1 answer
well please make up some fake data that looks like the real thing sow we have something to work from - the solution depends on how the "blank values" appear in the raw data - see https://jimdehner.com/2020/01/27/faq-series-not-all-nulls-are-created-equal/ we will need a twbx
