Populate a number of cells equal to value in one cell

[Botanybob]

I am rating 10 individual objects using a 1-5 numerical rating. I have data grouped by the rating value into 5 columns of data. For example the first column is the number of objects that received a 1 rating, so the 5 entries for a row might be 3, 0, 4, 3, 0 (3 #1s , 0 # 2s, 4# 3s, etc). I need to convert this data such that there are 10 different columns, with one rating event in each column... so instead of a reporting 3 objects received a 1 rating I need the values to be 1, 1, 1.... or 3, 3, 3, 3 for the #3s .

Thank you in advance for your assistance.

 

[Eric W]

If your ratings are in B2:B11, and you want your headers in E1:N1, try

E1: =SMALL($B$2:$B$11,COLUMNS($E$1:E$1))

then drag to the right.