row counts and transposing cell data

[raz2]

Hi,
I am new to coding but familiar with the principles and am looking for help on code to achieve the following:-
I have a single range of data (text) in columns A9:A90.
I have another single range, D8:L8, as column headings (text).
In between, D8:L90 I enter a number value which is a count of items associated with rows in the A9:A90 range, 0 to what ever...
So for example D9 may contain a 1, E9 a 5 and J40 a 3.
I am attempting to write code that takes this data and creates in new sheet individual rows for the total count within D8:L90 and associates them with corresponding values taken from A9:A90.
So where E9 contained a 5, output is
rowA9 data E8Heading (1st count)
rowA10 data E8Heading (2nd count)
rowA11 data E8Heading (3rd count)
rowA12 data E8Heading (4th count)
rowA13 data E8Heading (5th count)
I think it is straightforward (for gurus), I can now place data I need in arrays and get a count of contents of D8 : D90. It is the transposition and associated moves to new sheet which are a big learning curve for me! Any advice and pointers much appreciated...

[rbrhodes]

Hi raz2,

Perhaps post an example (before and after) of what you're trying to do.

[raz2]

Hi DR,

Thanks for response, the attached has an input tab which shows my data entries and an output tab that shows what i am trying to automate. the input tab array area is variable, I think its straight forward for an experienced programmer...

Raz2

[rbrhodes]

Hi raz2,

Try this code on **COPY** of your real data.

[raz2]

Hi DR,

:-)

This worked perfectly! Could I email you the full/real data set that i am working to, its the same principle but additional columns to manipulate and gaps in rows?

[rbrhodes]

Hi raz2,

Just click on my name in this post and choose "Send an email"