Spreadsheet: 148285d1333326521-concatenate-multiple-cells-crazy-stuff-products_osc_sample_help
Sheet: products(1)

products_id | products_quantity | products_model | products_image | products_image_med | products_image_lrg | products_image_sm_1 | products_image_xl_1 | products_image_sm_2 | products_image_xl_2 | products_image_sm_3 | products_image_xl_3 | products_image_sm_4 | products_image_xl_4 | products_image_sm_5 | products_image_xl_5 | products_image_sm_6 | products_image_xl_6 | products_price | products_date_added | products_last_modified | products_date_available | products_weight | products_status | products_tax_class_id | [NAME] | products_ordered | products_parent_id | products_price1 | products_price2 | products_price3 | products_price4 | [NAME] | products_price6 | products_price7 | products_price8 | products_price9 | products_price10 | products_price11 | products_price1_qty | products_price2_qty | products_price3_qty | products_price4_qty | products_price5_qty | products_price6_qty | products_price7_qty | products_price8_qty | products_price9_qty | products_price10_qty | products_price11_qty | products_qty_blocks | products_availability_id | products_color | nsubp | day1_sold | day7_sold | day30_sold
21527 | 1 | 5810 | 5810_1.jpg | 5810_on_md.jpg | 5810_on_lg.jpg |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.01 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 2
21528 | 0 | 5810 | 5810_1_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5810_1_lg.jpg | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 2 | 21527 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Green | 0 | 0 | 0 | 0
21529 | 1 | 5810 | 5810_2_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5810_2_lg.jpg | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 0 | 21527 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Red | 0 | 0 | 0 | 0
21530 | 1 | 5811 | 5811_1.jpg | 5811_on_md.jpg | 5811_on_lg.jpg |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.01 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | NULL | 2 | 0 | 0 | 0
21531 | 1 | 5811 | 5811_1_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5811_1_lg.jpg | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 0 | 21530 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Orange | 0 | 0 | 0 | 0
21532 | 1 | 5811 | 5811_2_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5811_2_lg.jpg | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 0 | 21530 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Green | 0 | 0 | 0 | 0
21533 | 1 | 5812 | 5812.jpg | 5812_on_md.jpg | 5812_on_lg.jpg |  |  |  |  |  |  |  |  |  |  |  |  | 22.5 | 2012-03-05 17:17:13 | 2012-03-07 13:04:03 | 2012-03-05 00:00:00 | 0.01 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 1
21534 | 0 | 5812 | 5812_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5812_lg.jpg | 22.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 1 | 21533 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Gold | 0 | 0 | 0 | 0
21535 | 1 | 5813 | 5813.jpg | 5813_on_md.jpg | 5813_on_lg.jpg |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 | 2012-03-05 17:17:14 | 2012-03-06 13:45:49 | 2012-03-05 00:00:00 | 0.01 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 1
21536 | 0 | 5813 | 5813_sm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5813_lg.jpg | 18.5 | 2012-03-05 17:17:14 | 2012-03-05 17:17:14 | 2012-03-05 00:00:00 | 0.1 | 0 | 1 | 2 | 1 | 21535 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | Black | 0 | 0 | 0 | 0
main products are in yellow, main products id in green
subproducts are below each main product in white rows
ie: first product is id 21527, this is a main product. It has two subproducts beneath, rows 3 & 4.
we are trying to move the subproduct data on the same line as the main product.
the only fields we need to extract and move from the subproducts are the blue, red and orange fields. Products_image, products_image_xl_6 and products_color
it should look something like below.
sample of the result (leaves above rows intact, but combines subproduct row data with main product data.
products_id | products_quantity | products_model | products_image | products_image_med | products_image_lrg | products_image_sm_1 | products_image_xl_1 | products_image_sm_2 | products_image_xl_2 | products_image_sm_3 | products_image_xl_3 | products_image_sm_4 | products_image_xl_4 | products_image_sm_5 | products_image_xl_5 | products_image_sm_6 | products_image_xl_6 | products_price | products_date_added | products_last_modified | products_date_available | products_weight | products_status | products_tax_class_id | [NAME] | products_ordered | products_parent_id | products_price1 | products_price2 | products_price3 | products_price4 | [NAME] | products_price6 | products_price7 | products_price8 | products_price9 | products_price10 | products_price11 | products_price1_qty | products_price2_qty | products_price3_qty | products_price4_qty | products_price5_qty | products_price6_qty | products_price7_qty | products_price8_qty | products_price9_qty | products_price10_qty | products_price11_qty | products_qty_blocks | products_availability_id | products_color | nsubp | day1_sold | day7_sold | day30_sold | subproduct 1 color | subproduct 1 large image | subproduct 2 color | subproduct 2 image | subproduct 1 small image | subproduct 2 small image
21527 | 1 | 5810 | 5810_1.jpg | 5810_on_md.jpg | 5810_on_lg.jpg |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 | 2012-03-05 17:17:13 | 2012-03-05 17:17:13 | 2012-03-05 00:00:00 | 0.01 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 2 | Available Colors~Green~ | 5810_1_lg.jpg | Available Colors~Red~ | 5810_2_lg.jpg | 5810_1_sm.jpg | 5810_2_sm.jpg