Extract data from a matrix

[aka_ash]

Hi 

I am looking to extract data from cells in a large excel matix.

I have a sample below with 3 different sets of data in a cell.

Below is the input and expected output

ideally i will expand the output further by splitting the 3 data identifiers in the cells

Matrix input:

	Data 1	Data 2	Data 3	Data 4	Data 5
Data 1		1:Low 2:High 3:High	1:Low 2:Low 3:High	1:Low 2:High 3:High	1:Low 2:High 3:Low
Data 2			1:High 2:High 3:High	1:Low 2:High 3:High	1:Low 2:High 3:High
Data 3				1:Low 2:High 3:High	1:Low 2:High 3:High
Data 4					1:Low 2:Low 3:High

initial output:

Title 1	Title 2	Output
Data 1	Data 1
Data 1	Data 2	1:Low 2:High 3:High
Data 1	Data 3	1:Low 2:Low 3:High
Data 1	Data 4	1:Low 2:High 3:High
Data 1	Data 5	1:Low 2:High 3:Low
Data 2	Data 1
Data 2	Data 2
Data 2	Data 3	1:High 2:High 3:High
Data 2	Data 4	1:Low 2:High 3:High
Data 2	Data 5	1:Low 2:High 3:High
Data 3	Data 1
Data 3	Data 2
Data 3	Data 3
Data 3	Data 4	1:Low 2:High 3:High
Data 3	Data 5	1:Low 2:High 3:High
Data 4	Data 1
Data 4	Data 2
Data 4	Data 3
Data 4	Data 4
Data 4	Data 5	1:Low 2:High 3:High

[cmcclellan]

The Transpose tool will do that (and a bit more) for you