Excel 2002: How to tranpose data to designated cells ?
 

Dear Sir,

I have the following table and would like the cell content of C21 and C22 to
be transposed to A24 and B24 respectively.

Debtor Analysis
A B C D E

21 H364 H364 H364
22 CGS LTD CGS LTD CGS LTD
23 AMT DUE CLAIMS PAYABLE
24 H364 CGS LTD 396,709 131,686 37,853
25 M006 M006 M006
26 DGF CO DGF CO DGF CO
27 AMT DUE CLAIMS PAYABLE
28 M006 DGF CO 206,150 489 156,925
29 T268 T268 T268
30 DK PLC DK PLC DK PLC
31 AMT DUE CLAIMS PAYABLE
32 T268 DK PLC 36,933 300 -


May I know what formula I must input at A21 and copy downwards to get the
answer for column A and B at row 24,28, 32 and so on?


Thanks

Low

--
A36B58K641

Excel 2002: How to tranpose data to designated cells ?
 

the simplest way is to go to A4
=C1
in B4
=C2
copy A1:B4
and paste to the end of your data

"Mr. Low" wrote:

Dear Sir,

I have the following table and would like the cell content of C21 and C22 to
be transposed to A24 and B24 respectively.

Debtor Analysis
A B C D E

21 H364 H364 H364
22 CGS LTD CGS LTD CGS LTD
23 AMT DUE CLAIMS PAYABLE
24 H364 CGS LTD 396,709 131,686 37,853
25 M006 M006 M006
26 DGF CO DGF CO DGF CO
27 AMT DUE CLAIMS PAYABLE
28 M006 DGF CO 206,150 489 156,925
29 T268 T268 T268
30 DK PLC DK PLC DK PLC
31 AMT DUE CLAIMS PAYABLE
32 T268 DK PLC 36,933 300 -


May I know what formula I must input at A21 and copy downwards to get the
answer for column A and B at row 24,28, 32 and so on?


Thanks

Low

--
A36B58K641

Excel 2002: How to tranpose data to designated cells ?
 

Hello bj,

Thanks for your simple method.

Low
--
A36B58K641


"bj" wrote:

the simplest way is to go to A4
=C1
in B4
=C2
copy A1:B4
and paste to the end of your data

"Mr. Low" wrote:

Dear Sir,

I have the following table and would like the cell content of C21 and C22 to
be transposed to A24 and B24 respectively.

Debtor Analysis
A B C D E

21 H364 H364 H364
22 CGS LTD CGS LTD CGS LTD
23 AMT DUE CLAIMS PAYABLE
24 H364 CGS LTD 396,709 131,686 37,853
25 M006 M006 M006
26 DGF CO DGF CO DGF CO
27 AMT DUE CLAIMS PAYABLE
28 M006 DGF CO 206,150 489 156,925
29 T268 T268 T268
30 DK PLC DK PLC DK PLC
31 AMT DUE CLAIMS PAYABLE
32 T268 DK PLC 36,933 300 -


May I know what formula I must input at A21 and copy downwards to get the
answer for column A and B at row 24,28, 32 and so on?


Thanks

Low

--
A36B58K641