I am sorry but I did not fully understand what you are looking for.
I am guessing you are looking for a solution to unpivot your table. If it is correct, please check this article: Loading Pivot Table.
If i did not understand it correctly please let me and the community know.
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
