Transpose columns to rows inserting lines & skipping bla

[alykat]

Hi there,

Would anybody be able to help me out with this one:

I have worksheet in which certain rows will need to be transposed into columns. Extra lines containing the information in the first row will need to be inserted, and any blanks skipped.

Let me show you what I mean:

******** ******************** ************************************************************************>

Microsoft Excel - Book1.xls ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A9 =
	A	B	C	D	E	F
1	What*I*have:	*	*	*	*	*
2	*	*	*	*	*	*
3	Name	Location	Transaction*A	Transaction*B	Transaction*C	Transaction*D
4	Mr*Jones	London	A	B	C	D
5	Mr*Smith	Blackpool	*	B	C	D
6	Mrs*Roberts	Liverpool	*	*	C	*
7	Miss*Smith	Manchester	A	*	C	D
8	*	*	*	*	*	*
9	What*I*would*like:	*	*	*	*	*
10	*	*	*	*	*	*
11	Name	Location	Transaction	*	*	*
12	Mr*Jones	London	A	*	*	*
13	Mr*Jones	London	B	*	*	*
14	Mr*Jones	London	C	*	*	*
15	Mr*Jones	London	D	*	*	*
16	Mr*Smith	Blackpool	B	*	*	*
17	Mr*Smith	Blackpool	C	*	*	*
18	Mr*Smith	Blackpool	D	*	*	*
19	Mrs*Roberts	Liverpool	C	*	*	*
20	Miss*Matthews	Manchester	A	*	*	*
21	Miss*Matthews	Manchester	C	*	*	*
22	Miss*Matthews	Manchester	D	*	*	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

Thanks again!