Forum Discussion
Form relationship between Table column and Table Headers AND multiple columns
I have three tables of data held within an excel workbook measuring compliance. I am trying to build a compliance dashboard that will allow me to see through any sort of visualisation the error r...
MFelix
Super User
Super UserHi Anonymous ,
You need to unpivot the columns on table C not transpose that way you will get the information in the same format, however there is a question about the unpivot is that all the columns that you don't unpivot are repeated and this can cause values to be repeated where you don't want them repeated.
In this case are all of the percentages values also part of your Table A categoy or only the two columns identified?