I have a column of text only information in A1 thru A26, with a control
number in A27.
I want to copy A1 thru A26 to C1 and transpose that column (values only) to
that row.
Then I want to repeat that same copy (for the number of times that is
indicated in A27.
I would then like to go to the bottom of column C and and go down 4 rows
below the last row and put a formula that counts the numberof times that the
information in row 1 occurs in the rows below it.
And finally I would like to copy that formula across the rows for the
transposed information..

Each time I have tried to do this in a recorded macro I couldn't get it to
work, mostly because of the formula and the location of the bottom of the
row, which seems to go to the wrong place. I would appreciated any help and
thank you in advance.


Chuck C