Data into multiple cells and rows

[consth21]

I was wondering how I would go about putting a cell's output into multiple cells and rows. For example, I would like to do a repeat function in a cell, depending on numbers in a previous sheet.
=REPT("thickness, ",A1-1)&TEXT("thickness",1)
A1 ranges from 5-56. In all cases, the output of this cell is greater than 5 columns wide. I can only have an output that is 5 columns and the remaining needs to go into rows. How would I be able to go about doing this? I would like output to be something like this....
thickness, thickness, thickness, thickness, thickness,
thickness, thickness

Thank you in advance. I just found out about this website today and there is some great information on it. It's too bad that I didn't find out about earlier.

Heidi

 

[consth21]

Thank you Eric for all of your time. I got everything working now!!
Heidi

 

[erik.van.geit]

Heidi,

Glad that you finally got it!
My heart is happy too!
Could you tell in a few words what happened? What was the final "click" in your mind to make it work? What didn't you see at first?
It would really be useful to know this, so we can help better in the future.

kind regards,
Erik