View My Drafts
I have a table that contains multiple columns with multiple values and I need to format it into a "key value" from the first column with multiple columns made from the values in the second column. The key column is an office name I then have multiple rows for client, main contractor and operator relating to this office name that I want to show as columns NOT rows i.e. I have one row per office name.I have attached the file.
Do you want to change the Model or you want to view data as Pivoted ?- To change the data as Pivoted you can use "Matrix" table visual and put "Site Name" in Rows and "Office name" in Columns and put measures in Values.But when you will Pivot the data whether in Data Model,this will create Column of every unique data in your Office Name. Therefore you will have many columns and it will be very hard for you to handle.Therefor I will suggest you to create a Matrix Table and Site name as Filter so that you will have column related to that particular Site only.Attached is for your reference.