Convert data layout macro

[jwst87]

Hi all,

I have a large amount of data showing time taken by employees performing specific tasks that is currently in the fallowing layout:

NAME Task1 Task2 Task3 Task4 Task5
James 25 5 0 20 45
Andrew 90 25 0 10 20
Sarah 120 30 0 5 70

I would like to convert it into the following layout to make it easier to reference and create pivot tables from:

NAME TASK Time
James Task1 25
James Task4 20
Sarah Task3 0

So far doing this manually has proven to be very time consuming, I was wondering if it was possible to create a macro to do the work for me?

Cheers

Jon

 

[Aaron Blood]

@ Lenze,

I think he just copy/pasted our code without updating range refs for where his data resides.

 

[jwst87]

All sorted, I had updated the ranges however I had saved the macro in my PERSONAL.xls as opposed to the the actual worksheet I was working from, so my hidden sheet was getting updated over and over again.

The one with the range selection seems to be just the thing i'm looking for, thanks both for helping me with this.

Jon

 

[smoskowitz]

This code is fantastic.....how would I do the reverse. I want to convert the the output you showed into the original data format.