Transpose

[#1]

Hi All

I have large piece of data in the format (see below). I am looking to transpose in the format (see below)

		01/04/2013		01/05/2013		01/06/2013
Code	Name	Num	Denom	Num	Denom	Num	Denom
NY	New York	20	3	30	6	40	3
LON	London	21	4	31	7	41	4
BIR	Birmingham	22	5	32	8	42	5
CAR	Cardiff	23	6	33	9	43	6
MAN	Manchester	24	7	34	5	44	7

After Transpose:(to look like)

Code	Name	Month	Num	Denom
NY	New York	01/04/2013	20	3
NY	New York	01/05/2013	30	6
NY	New York	01/06/2013	40	3
LON	London	01/04/2013	21	4
LON	London	01/05/2013	31	7
LON	London	01/06/2013	41	4
BIR	Birmingham	01/04/2013	22	5
BIR	Birmingham	01/05/2013	32	8
BIR	Birmingham	01/06/2013	42	5
CAR	Cardiff	01/04/2013	23	6
CAR	Cardiff	01/05/2013	33	9
CAR	Cardiff	01/06/2013	43	6
MAN	Manchester	01/04/2013	24	7
MAN	Manchester	01/05/2013	34	5
MAN	Manchester	01/06/2013	44	7

[#2]

Thanks Chris.

It works if I am using only one work book. Doesnt work if I have multiple workbooks with multiple sheets.Please see attached.

[#3]

Here is a solution using "CrossTable"  function

it might be a way to load many files with many sheets

and the script is a lot momre simple

best regards

Chris

[#4]

Thanks Christian.

How can I embed the multiple loading of sheets in Transpose code as that is what I am trying to achieve please.

[#5]

Hi don't understand

in my example  i load 2 files with 3 sheets each.

Isn't it what you want?

doesn't matter how many files and sheets you are using

if more than 3 sheets just add in the For each list

chris