Hi
Is there an easy way to convert a matrix type table into a list in Excel?
I have uploaded an example worksheet. The yellow shaded section is the matrix and the blue shaded section is the list I would like to achieve.
I think it may be VBA if anything???
many thanks for any help.
Is there an easy way to convert a matrix type table into a list in Excel?
I have uploaded an example worksheet. The yellow shaded section is the matrix and the blue shaded section is the list I would like to achieve.
I think it may be VBA if anything???
many thanks for any help.