Duplicate Cells If

[jhere01]

hello, Need help to find a way to duplicate certain cells depending on a value in a cell.
example:
column A shows Qty, column B shows Location, column C, D, E..... will show value of column B depending on QTY in column A.

QTY	Location	1	2	3	4
2	181201	181201	181201
1	182411	182411
3	183011	183011	183011	183011
4	184021	184021	184021	184021	184021

<tbody>
</tbody>

 

[dreid1011]

One option:

=IF(COLUMNS($C$2:C2)-$A2<=0,$B2,"")

Copy across and down.

 

[jhere01]

Thank you very Much! Worked!!!

 

[dreid1011]

Thank you very Much! Worked!!!

You're welcome.