Trying to figure out how to put normalized flat data into matrix

[CMSGuy]

Here is a small sample of the data I am pulling in from a SharePoint list:

The column names are T1, T2, T3...T33 and each have some corresponding values.  Not shown here is some other data including a date of recording, a person, and a Title.  I am filtering based on date: year, month (showing a row of days by month in the matrix even if there is no data so each day is represented); then filtering by Person and finally a Title.  The Title has an ID that will correspond to each of these Tn values.  What I am trying to do is to create a matrix with that day of the month column and then create columns with the value of Tn IF THERE IS DATA; and then display the TnIS value in the corresponding cell.  

Any advice to do this is much appreciated.  I have tried copying out the original query and selecting columns to unpivot and that does come up with Attribute and Value, but if I do that how does that table relate to the main data table?

[Ashish_Mathur]

Hi,

Share data in an MS Excel file format.  Please show the expected result clearly.

[guyinazo]

Ashish, I was going to reply yesterday, but I could not get into the forums.  Here is a link to some sample data.  It is an excel sheet with data and then a tab (OUT) for desired outcomes.  Thanks https://1drv.ms/x/s!AmGs3dP-UuFFjr9-KSzsJVjNmlm2Uw?e=U4Qs0h 

PS (I am using a different account to reply to you. I have a business and personal acct)

[Ashish_Mathur · Accepted solution]

Hi,

I cannot understand your desired result.  Anyways, i have transformed your data to enable to now get your desired result.  You may download my PBI file from here.

Hope this helps.