Convert Data Horizontal To Vertical

i have data in horizontal formate but i want to convert it to vertical i.e in columns. how to?

Hi,

I have data in a horizontal format that I would like to convert into a vertical format.

The following is an extract of the data -:

Postcode Trade 01-Apr 02-Apr 03-Apr 04-Apr 05-Apr
AB A 1 1 1 1 2
AB B 1 1 1 0 1
AB C 1 1 1 1 2
AB D 3 3 2 2 4
AB E 0 0 0 0 1
AB F 1 1 0 0 1
AB G 0 0 0 0
AL A 3 3 2 2 4
AL B 1 1 1 1 2
AL C 1 1 1 1 2
AL D 3 3 2 2 4
AL E 6 6 5 4 8
AL F 1 1 1 0 1
AL G 1 1 1 1 2
AL H 1 1 0 0 1

The columns extend right out to 31-Mar i.e one for each day of the year.
----------------------------------------------------------------------------------------------------------------------------------

I have been asked to present the data, vertically, as follows -:

Postcode Date Trade Amount
AB 01-Apr-10 A 1
AB 02-Apr-10 B 1
AB 03-Apr-10 C 1
AB 04-Apr-10 D 1
AB 05-Apr-10 E 2

i.e. each day of the year has to be listed against each category in the Trade column. This makes a total of over 300k rows. I have went through the painful process of copying and pasting (transposing) and I have done all the postcodes and dates.

Would anybody know any way of formulating the amount across from horizontal to vertical? I have looked into a few different formulas to no avail.

Thanks

Hi guys,

I was wondering if there is a way to convert a tri-matrix (output of genetics software "MICROSAT") into a single column in excel. The resulting column needs to have both the vertical id (A-G) and the horizontal id (A-G) for each cell (0-6). Examples follow:

Tri-matrix
id A B C D E F G
A 0
B 1 0
C 1 2 0
D 1 2 3 0
E 1 2 3 4 0
F 1 2 3 4 5 0
G 1 2 3 4 5 6 0

Column
vertical id, horizontal id, value.
A, A, 0.
B, A, 1.
C, A, 2.
D, A, 3.
E, A, 4.
F, A, 5.
G, A, 6.
B, B, 0.
C, B, 1.
D, B, 2.
E, B, 3.
F, B, 4.
G, B, 5.
C, C, 0.
D, C, 1.
E, C, 2.
F, C, 3.
G, C, 4.

ect.

The tri-matrix I am trying to convert has about 20,000 records.

Any help would be much appreciated.

Cheers,

Dave

Is this possible ro do I need to convert to vertical? If so how do I convert to vertical? Would prefer horizontal autofiltering if possible though'

thanks

Kindly please help to convert from Horizontal To Vertical Format. Its about 1000 rows The sample data are,

Item Desc Item2 Desc2 Qty
1 A 1A 1AA 1
1 A 1B 1BB 2
1 A 1C 1CC 3
2 B 2A 2AB 1
2 B 2B 2BB 7
3 C 3C 3CC 10

Results Required will be,

Item Desc Item2 Desc2 Qty Item2 Desc2 Qty Item2 Desc2 Qty
1 A 1A 1AA 1 1B 1BB 2 1C 1CC 3
2 B 2A 2AB 1 2B 2BB 7
3 C 3C 3CC 10

Thank you.