Transposing large amounts of data

[salva7ore]

Hello,
I am new to this forum and have never posted anything.
I am not familiar with macros and I am faced with the task of having to handle the transposition of large amounts of data from a horizontal dimension into a vertical dimension.

My data set looks like this:

Row 1 contains 111 columns (111 different titled colums for payroll element from A to DG, eg.Name, Surname, Payroll ref, Tax, Ni, Pension, etc).
Each row contains the payroll information in relation to one unique employee.
There are 3681 employees (3681 rows excluding the title).

The macro would transpose and rearrange the data from this:

A B C D E F G......................DG
1 Name Surname Payroll Ref Tax NI Pension Net Pay
2 Joe Blogg 12345 £5 £7 £8 £120
3 Lian Stuck 54321 £4 £6 £9 £100
.
.
.
3681

to this format:

A B C D E
1 Name Surname Payroll Ref Element Amount
2 Joe Blogg 12345 Tax £5
3 Joe Blogg 12345 NI £7
4 Joe Blogg 12345 Pension £8
5 Joe Blogg 12345 Net Pay £120
6 Lian Stuck 54321 Tax £4
7 Lian Stuck 54321 NI £6
8 Lian Stuck 54321 Pension £9
9 Lian Stuck 54321 Net Pay £100

The macro would only create a new row for any element that contains a value.

A similar problem has been posted by someone else in this forum but the solution provided there can't make it work here
because of my poor understanding of macros.

http://www.excelforum.com/excel-prog...ml#post3659527

I hope that the above is clear.

Any help will be greatly appreciated.
Many thanks.
Sal

[AB33]

Sal,
It is difficult to see the input and output data in text format. Please attach a sample in excel book which shows before and after running the code.