how do i create a report from a matrix
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
|