Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reorganize list
Hello! I'm not sure if this is the right Excel group to post this question
in, but I am hopeful that someone can point me in the right direction: I have a worksheet where all the rows represent tasks and the columns are named "Requirements", "Build", "Test", "Deploy". The intersection of the rows and columns have a numeric value (hours). I would like to move this data into a separate worksheet where there is a row for each task, but where the columns from the original worksheet ("Requirements", "Design", "Build", etc.) are now repeated beneath each task with the original numeric data (hours) in the adjacent column. So, I have this: Requirements Design Build Task 1 8 5 10 Task 2 5 10 8 And want it to show up on another worksheet like this: Task 1 Requirements 8 Design 5 Build 10 Task 2 Requirements 5 Design 10 Build 8 Does anyone have an example of a macro or worksheet functions that can do this? Another point is that the original list will change, so I need to be able to dynamically recreate the new worksheet as changes occur. Thank you! |
#2
|
|||
|
|||
John Walkenbach has a technique that comes very close to what you want at:
http://j-walk.com/ss/excel/usertips/tip068.htm DWeb wrote: Hello! I'm not sure if this is the right Excel group to post this question in, but I am hopeful that someone can point me in the right direction: I have a worksheet where all the rows represent tasks and the columns are named "Requirements", "Build", "Test", "Deploy". The intersection of the rows and columns have a numeric value (hours). I would like to move this data into a separate worksheet where there is a row for each task, but where the columns from the original worksheet ("Requirements", "Design", "Build", etc.) are now repeated beneath each task with the original numeric data (hours) in the adjacent column. So, I have this: Requirements Design Build Task 1 8 5 10 Task 2 5 10 8 And want it to show up on another worksheet like this: Task 1 Requirements 8 Design 5 Build 10 Task 2 Requirements 5 Design 10 Build 8 Does anyone have an example of a macro or worksheet functions that can do this? Another point is that the original list will change, so I need to be able to dynamically recreate the new worksheet as changes occur. Thank you! -- Dave Peterson |
#3
|
|||
|
|||
Thank you! I used this technique which got me on the way to the outcome I'm
looking for. "Dave Peterson" wrote: John Walkenbach has a technique that comes very close to what you want at: http://j-walk.com/ss/excel/usertips/tip068.htm DWeb wrote: Hello! I'm not sure if this is the right Excel group to post this question in, but I am hopeful that someone can point me in the right direction: I have a worksheet where all the rows represent tasks and the columns are named "Requirements", "Build", "Test", "Deploy". The intersection of the rows and columns have a numeric value (hours). I would like to move this data into a separate worksheet where there is a row for each task, but where the columns from the original worksheet ("Requirements", "Design", "Build", etc.) are now repeated beneath each task with the original numeric data (hours) in the adjacent column. So, I have this: Requirements Design Build Task 1 8 5 10 Task 2 5 10 8 And want it to show up on another worksheet like this: Task 1 Requirements 8 Design 5 Build 10 Task 2 Requirements 5 Design 10 Build 8 Does anyone have an example of a macro or worksheet functions that can do this? Another point is that the original list will change, so I need to be able to dynamically recreate the new worksheet as changes occur. Thank you! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions | |||
Creating a list from an existing list. | Excel Worksheet Functions |