Hi,
Is there a simple way of transforming this table:
Resource 1 Resource 2 Resource 3
Activity 1 5 4 5
Activity 2 4 5 6
Activity 3 5 3 5
Into something like this:
Activity 1 Resource 1 5
Activity 1 Resource 2 4
Activity 1 Resource 3 5
Activity 2 Resource 1 4
Activity 2 Resource 2 5
Activity 2 Resource 3 6
Activity 3 Resource 1 5
Activity 3 Resource 2 3
Activity 3 Resource 3 5
Btw, I am hopeless at VBA and macros.
Thank you very much in advance.
Please attach a sample workbook - as there is some ambiguity about what values are in which cell, in your post. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
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
OK. Figured it!! Try this.
Thanks for figuring it out (I was still figuring out how to write a table on the thread).
I'm going to give it a try. I'll let you know if I got it to work.
For future reference to attach a spreadsheet, click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Hi again,
Glenn,
Thank you for your help, it was great!
I managed to make it work, but I wasn't able to figure out how to do the same with the headers (please see the attached file).
Any ideas?
Thank you.
OK. I missed that bit.
Paste this into H2 and copy down...
=OFFSET($B$1,,MOD((ROWS($1:1)-1),3),,)
Worked.
Thank you so much.
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks