I have sample data as you mentioned and done the calculation like below. Also, I have attached the workbook for your reference.
Please mark this answer as a correct answer or helpful if it solves your requirement.
Thank you for your quick response, could you please send the workbook once again while opening the workbook showing an error.
Find my approach below,
Fist you need to split all the fields like this,
Repeat the above steps for other fields (Recordings, Values)
Once done you'll have this view
Now create few calculated field to concatenate split fields from (Date,Recordings,Values)
Split 1: [Date - Split 1]+','+[Recordings - Split 1]+','+[Values - Split 1]
split 2: [Date - Split 2]+','+[Recordings - Split 2]+','+[Values - Split 2]
Split 3: [Date - Split 3]+','+[Recordings - Split 3]+','+[Values - Split 3]
Now bring this source to excel and delete all the fields except calculated Split 1, 2, and 3 which you've created.
Once done then connect the remaining data in tableau and pivot
after pivot you'll have something like this. Go to sheet and use the pivot field values in you canvas and check
Note: If this is one time activity then you can follow this approach else I'd recommend don't do this data cleaning and reshaping manually use any ETL tool for this.