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.