By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

Transposing cells in Excel

P: 33
Hi guys

I am have two excel workbooks. One book has data formatted according rows. Example:
Expand|Select|Wrap|Line Numbers
  1. ROW 1: Loan # ; Principal Amount ; Interest Rate ; Date
The other book needs to be formatted so that it contains a column that looks like:
Expand|Select|Wrap|Line Numbers
  1. COLUMN: 
  2.              Loan #
  3.              Principal Amount
  4.              Interest Rate
  5.              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:
Expand|Select|Wrap|Line Numbers
  1. Start by selecting a row
  2. Click a button for macro to run
  3. Have macro display information from row in Book 1 into column in Book 2.
Sep 25 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
You can create this by activating the macro recorder and use the "Transpose" possibility in sheet 2 when pasting the selected fields from row1.

Sep 27 '08 #2

Expert Mod 15k+
P: 31,660
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 :
Expand|Select|Wrap|Line Numbers
  1. 1A 1B 1C
  2. 2A 2B 2C
Do you want results of :
Expand|Select|Wrap|Line Numbers
  1. 1A 2A
  2. 1B 2B
  3. 1C 2C
or :
Expand|Select|Wrap|Line Numbers
  1. 1A
  2. 1B
  3. 1C
  4. 2A
  5. 2B
  6. 2C
Sep 29 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.