Forum Discussion
Formula to create concatenated size data for groups of products
I have the following data: Product Name Size All sizes Maxomorra Bikini Bottom Rainbow Age 9-10 Yrs Maxomorra Bikini Bottom Rainbow Age 11-12 Yrs Maxomorra Bikini Top Rainbow ...
OliverScheurich hi there. Thanks for the reply. I am trying to use basic formulae to do this as this file is generated from another excel with various pieces of product data. Ideally I would be able to just input the size data from the original manufacturer supplied file and then copy the formula down without the need for further manipulation.
Once this file is created it is used as a .csv to upload product data to site.
=IFERROR(INDEX(Tabelle2!$B$2:$B$21,SMALL(IF(Tabelle2!$A$2:$A$21=Tabelle2!$A2,ROW(Tabelle2!$A$2:$A$21)),COLUMN(A$1))-1),"")You are welcome. You can try this formula which works in Excel 2013. Enter the formula with ctrl+shift+enter in order to confirm it as an arrayformula. The formula is filled down and to the right in the attached samplefile.