Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I've got a big table, about 70 'work divisions' down the side and arround 200 document titles across the top. The cells in the table contain wither x (if that document is reference to that work division in list x) or y (if that document is referenced to that work division in list y) or b if it appears in both.
Anyone know a way of generating a report/table telling which just lists work divisions and a list of documents associtated with it?
Use the auto filter function?
For work divisions, transpose the data and do the same.
This will only work for one at a time though.
If you want to do them all in a oner, it gets a bit more involved.
hmmm, transpose the table, auto filter, and write a macro to copy the list of documents still showing, might work 🙂
Pivot tables?
If you got it all into 3 columns
Work Division, Document Title, List x y or b
You could then use the pivot table report - or autofilter.
You are going to have to piss about with macros of some sort until the data is normalised.