trasnspose

[sal21]

01/12/2003 63,58-
950495107
01/12/2003 97,82-
950495156
01/12/2003 127,15-
950495185
01/12/2003 152,76-
950495157
01/12/2003 158,94-
950495210
01/12/2003 211,92-
950495266
03/12/2003 219,12-

i have 2 column:

A is date
B 2 value

my prob is to transpose in column C in this mode

01/12/2003 63,58- 950495107
01/12/2003 97,82- 950495156
....

 

[Guest]

This takes a little work, but I assume you have a very large file

1) Copy column B and Paste in column

2) Delete cell C1. Excel should ask how you want to shift the cells. Select Shift cells up

3) In D1 enter 1, in D2 enter 2, select both cells, grab black square in lower corner of selection and drag to bottom of list. This will create a series of numbers. You will use this to resort the list

4) Sort on column A, and delete all of the excess stuff at the bottom

5) Resort on column D, and delete column

Good Luck
Mark Graesse
(e-mail address removed)

----- sal21 wrote: ----

01/12/2003 63,58
95049510
01/12/2003 97,82
95049515
01/12/2003 127,15
95049518
01/12/2003 152,76
95049515
01/12/2003 158,94
95049521
01/12/2003 211,92
95049526
03/12/2003 219,12

i have 2 column

A is dat
B 2 valu

my prob is to transpose in column C in this mod

01/12/2003 63,58- 95049510
01/12/2003 97,82- 95049515
...