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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]QTY[/TD]
[TD]Location[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]181201[/TD]
[TD]181201[/TD]
[TD]181201[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]182411[/TD]
[TD]182411[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]183011[/TD]
[TD]183011[/TD]
[TD]183011[/TD]
[TD]183011[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]184021[/TD]
[TD]184021[/TD]
[TD]184021[/TD]
[TD]184021[/TD]
[TD]184021[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.