how do i create a report from a matrix

D

dunskii

Hello again,
I have a matrix that I want to export into word as a report. I have 3
worksheets in my spreadsheet, 2 are lists with names and other info and 1
matrix (which uses the names from the 2 lists as the headers). I now need to
create lists that represent the matrix in text form that also has details
from the other 2 sheets.

eg
My Matrix
Dep1 Dep2 Dep3 Dep4
Sw1 x x
Sw2 x x x
Sw3 x x
Sw4 x x

Text Form
Dep1 - Sw1, Sw1 info, Sw2, Sw2 info, Sw4, Sw4 info
Dep2 - Sw2, Sw2 info, Sw3, Sw3 info
Dep4 - Sw1, Sw1 info, Sw3, Sw3 info

I hope that makes sense,
Thanks in advance,
d
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increaseing the number of aurguments in a function 4
Extracting data from a product matrix 0
Name Matrix 2
How would I create a report from data in a matrix 0
How to create a correlation matrix in excel? 6
Is This a Pivot? A SumProduct? A SumPivot? Matrix? 1
Creating a Cross Reference table/Matrix 2
how do i add lable to the points in the chart, 1

Top