Good morning - yes that is ugly -
Is this a one time change that you will use to correct the data structure then move on - if so you could use Tableau Prep to clean and pivot the file
Thanks for your quick reply, Jim.
Unfortunately we do not have Tableau Prep available.
We need the change to then move on with our analysis - so it is a long-term thing.
That's why we were rather looking for some calculated fields to imitate a pivot in order to reduce the run times.
2 of 2 people found this helpful
see the attached - i'm not certain this is any easier but it is worth a look
first I created a scaffold (see the excel sheet) - there is a sheet for Products , one of ID's and a third for you matrix
then created 3 calculated fields one for each "Item"
then an lod to total
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.