I'm wanting to concatenate some rows dependent upon if they are a different value.
So in column C i want to say =IF(D2="Variable",concatenate(c3,c4),c2)
So i need the formula to check if parent sku is the same as the child sku, then if it does, then concatenate both of them skus together, and display in the cell C2?
[TABLE="width: 500"]
<tbody>[TR]
[TD]SKU
[/TD]
[TD]Parent Sku
[/TD]
[TD]Variable value
[/TD]
[TD]Product Type
[/TD]
[/TR]
[TR]
[TD]Parent1
[/TD]
[TD][/TD]
[TD]Blonde, Brown
[/TD]
[TD]Variable
[/TD]
[/TR]
[TR]
[TD]Child1
[/TD]
[TD]Parent1
[/TD]
[TD]Blonde
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Child2
[/TD]
[TD]Parent1
[/TD]
[TD]Brown
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Daddy1
[/TD]
[TD][/TD]
[TD]Blonde, Brown, Ginger
[/TD]
[TD]variable
[/TD]
[/TR]
[TR]
[TD]Baby1
[/TD]
[TD]Daddy1
[/TD]
[TD]Blonde
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Baby2
[/TD]
[TD]Daddy1
[/TD]
[TD]Brown
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Baby3
[/TD]
[TD]Daddy1
[/TD]
[TD]Ginger
[/TD]
[TD]variation
[/TD]
[/TR]
</tbody>[/TABLE]
So in column C i want to say =IF(D2="Variable",concatenate(c3,c4),c2)
So i need the formula to check if parent sku is the same as the child sku, then if it does, then concatenate both of them skus together, and display in the cell C2?
[TABLE="width: 500"]
<tbody>[TR]
[TD]SKU
[/TD]
[TD]Parent Sku
[/TD]
[TD]Variable value
[/TD]
[TD]Product Type
[/TD]
[/TR]
[TR]
[TD]Parent1
[/TD]
[TD][/TD]
[TD]Blonde, Brown
[/TD]
[TD]Variable
[/TD]
[/TR]
[TR]
[TD]Child1
[/TD]
[TD]Parent1
[/TD]
[TD]Blonde
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Child2
[/TD]
[TD]Parent1
[/TD]
[TD]Brown
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Daddy1
[/TD]
[TD][/TD]
[TD]Blonde, Brown, Ginger
[/TD]
[TD]variable
[/TD]
[/TR]
[TR]
[TD]Baby1
[/TD]
[TD]Daddy1
[/TD]
[TD]Blonde
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Baby2
[/TD]
[TD]Daddy1
[/TD]
[TD]Brown
[/TD]
[TD]variation
[/TD]
[/TR]
[TR]
[TD]Baby3
[/TD]
[TD]Daddy1
[/TD]
[TD]Ginger
[/TD]
[TD]variation
[/TD]
[/TR]
</tbody>[/TABLE]