I'm currently working on different excel sheets which have this kind of structure :
Obviously, I can't work with this chart without doing modifications.
I would like to obltain this kind of view to work on Tableau Software to make analysis.
I tried to do it with "code 1" and "code 2" which are numbers with a "isnull" and "previous_value" formula, but didn't work. Any idea ? Hope it's clear !!
You can't fix this in Tableau Desktop, you need Tableau Prep (that MIGHT do it), or some other functionality (maybe another sheet in Excel ?) to get the data in the proper format