I have excel file where the data is in horizontal manner. I have an output in access table, in vertical manner.
I have a snap shot of data which I would like to attach which better describes my issue. Let me how I can attach.

So if you see the excel i have employees and Dept that I need to apply to all my projects with the respective percentages. I have similar data across many sheets in excel, so I have created a column in...