Transposing cells in Excel

[owuraku]

Hi guys

I am have two excel workbooks. One book has data formatted according rows. Example:

ROW 1: Loan # ; Principal Amount ; Interest Rate ; Date
 

The other book needs to be formatted so that it contains a column that looks like:

COLUMN: 
             Loan #
             Principal Amount
             Interest Rate
             Date
 

Note that while there are several rows in Book 1, Book 2 should only have ONE column whose values for Loan # ; Principal Amount ; Interest Rate ; Date change depending on the Row selected in Book 1.

What would be the best approach? I am thinking a macro should do:

Start by selecting a row
Click a button for macro to run
Have macro display information from row in Book 1 into column in Book 2.
 

[nico5038]

You can create this by activating the macro recorder and use the "Transpose" possibility in sheet 2 when pasting the selected fields from row1.

Nic;o)

[NeoPa]

It would be helpful if you clarified your question with some example data.

Is this a simple transpose? Do you need multiple rows to merge into one single column?

If your starting data is :

1A 1B 1C
2A 2B 2C

Do you want results of :

1A 2A
1B 2B
1C 2C

or :

1A
1B
1C
2A
2B
2C