how to transpose columns into rows

[Joschi23]

Hi,

How do I transpose columns into rows; please check the attached file to understand exactly what I mean.

Thanks in advance!
Joschi

[jeffreybrown]

See if this sample helps

[Joschi23]

first thanks for the fast reply
but no unfortunately it does not help, because I need payment and also period to be each in one column only

any ideas?

[brharrii]

Are you trying to combine them to 1 column?

Maybe I'm missing something. Initially it sounded like the question was how to change the columns into rows.
- Copy column
- right click destination cell
- Paste Special
- Check "transpose" box
- "ok"

I'm not following what you mean by that you need them in one column only.

[shadrack]

Check-out this one. However, I do not really understand your problem. Forgive me if I gave wrong answer.

[Joschi23]

the problem is that I need the first table (in reality it has 6500 lines) to be in the form of the second table (please look at my original file);
so I have the payments all in one column, the periods all in the second column, sorted by Borrower ID and Loan ID