I have a table where the month and year heading are setup as rows and the product heading setup as column (column C through L). I would like a formula to transpose year and month into the new headings for the new table while the product list is will be the new row. I think the combination of index, column and some other excel functions can achieve this task.
Desired outcome is in green color.
Sample data is attached.
Thanks
Any reason why you casn't just use copy and paste special transpose?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
This is to accommodate new data entry in column A and B and across columns (columns as fixed - that is product 1 to product 10). However, month and year in the original table will be populated and want the new table to be respond to new data entered.
Thanks.
In d25 and copy down and across.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Please see attached file with formulas.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Fotis1991: Is there s way to use formula to transpose the column in the original table to rows, and also transpose the rows (month and year) to columns with formula? The sumproduct formula works. thanks.
AlKey: The work works like a charm. Thanks for the excellent work.
You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * .
Last edited by AlKey; 05-26-2014 at 11:41 AM.
File updated
Last edited by bjnockle; 05-26-2014 at 08:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks