• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Transposing data from one worksheet to different worksheets

S

Sheela

New Member
Hello Excel Ninjas,

I have two questions:

My data is arranged in a table in the "Data" worksheet.

Question 1:
The individuals John, Amy, Beth and Don have under Column C quantities ordered for (1-wk, 2-wk, 3-wk, 4-wk, 5-wk) arranged in rows.
I want to transpose the values from worksheet "Data" Column C to worksheet "Number_1" for the individuals John, Amy, Beth and Don. I have used the index function to do so for John.
How would I automate the process to get the values for Amy, Beth and Don?

Question 2:
The individuals John, Amy, Beth and Don have under Column D, "Goods_1" Mango, Pear and Banana arranged in rows.
Each individual has values under Column E "Value-Goods_1" for 1-wk, 2-wk, 3-wk, 4-wk, 5-wk for Mango, Pear and Banana.
How would I transpose the numbers for John and Beth from worksheet "Data" to worksheet "Mango"?
How would I transpose the numbers for Amy from worksheet "Data" to worksheet "Pear"?
How would I transpose the numbers for Don from worksheet "Data" to worksheet "Banana"?

I really appreciate your help.

Thanks

Sheela
I am having trouble uploading the excel file. Any suggestions?
 
I have also experienced issues with uploading files recently. Restarting windows appears to fix it - I wish I could offer a better fix ...

You will need to find a way to get it on here to get a quick answer ...
 
Hi Hui,
Thank you for your quick response. I am trying to understand how the formula works: If I try to copy across rows from column B2 to F2, it does not work. Do I have to manually enter the formula for each of the columns for row 2. When I select Column 2 Row 2 and copy down the numbers are populated. Is there a way to copy across the columns?
How would I use the sumif formula? If there are blank cells, I do not wish to have "0" entered in the cells. How do i address this? In the spreadsheet using the formula you entered, there is a "0" in the blank cells.

Thanks a lot
Sheela
 
The formula in B2 copies directly to all the other cells in the Table
The problem in F2 is that there are no values in 5-wk in the Data Worksheet
 
You must log in or register to reply here.
Back
Top