+ Reply to Thread
Results 1 to 2 of 2

Concatenate multiple rows into 1 cell with carriage returns - slightly more advanced.

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    Southend-on-sea, England
    MS-Off Ver
    2007
    Posts
    2

    Concatenate multiple rows into 1 cell with carriage returns - slightly more advanced.

    This is my first post so I would like to say helloto everyone.
    Every Excel problem I've had so far I have found a solution on the forum but this time I'm stumped.

    long story short, my website has many product images - up until now the parent image has shown above the children images. The site will only now show parent image. I have exported all product images (parent and child) and with the right formula could import the child images in the same cell as parent images. (1 product tested and it works)

    VS Parent ID VS Child ID Parent Reference Child Reference Child Product Images
    4573 99967 PE6030 PE6030White/ Black http://www.b-id.co.uk/images/product...5-17452700.jpg
    4573 99968 PE6030 PE6030White/ Green http://www.b-id.co.uk/images/product...0-14622700.jpg
    4573 99969 PE6030 PE6030White/ Light Blue http://www.b-id.co.uk/images/product...1-10525300.jpg
    4573 99970 PE6030 PE6030White/ Navy http://www.b-id.co.uk/images/product...6-36322600.jpg
    4573 99971 PE6030 PE6030White/ Orange http://www.b-id.co.uk/images/product...9-06755300.jpg
    4573 99972 PE6030 PE6030White/ Red http://www.b-id.co.uk/images/product...7-92248800.jpg

    How can you concatenate all child image URLs where parent ID (4573 in this case) is the same? The relevant urls need to be in 1 cell with hard carriage return between each one. there are 95,000 SKUs in my CSV export.

    Thank you in advance for reading this and for any help.
    Kyle.

  2. #2
    Registered User
    Join Date
    08-19-2016
    Location
    Southend-on-sea, England
    MS-Off Ver
    2007
    Posts
    2

    Re: Concatenate multiple rows into 1 cell with carriage returns - slightly more advanced.

    2 product example.xlsx

    This should be an example of 2 product lines as per export.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove multiple Carriage Returns - macro to clean cell contents
    By Deskjocky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 01:52 PM
  2. Carriage returns in a concatenate formula ?
    By SimonL in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2013, 01:31 AM
  3. Replies: 13
    Last Post: 02-24-2012, 12:14 PM
  4. Remove Carriage Returns From Target Cell
    By JoJo in forum Excel General
    Replies: 1
    Last Post: 03-22-2007, 05:23 PM
  5. How do I eliminate carriage returns in a cell
    By Squirrelwatcher in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-07-2005, 11:40 AM
  6. VBA: Concatenate with carriage returns
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2005, 09:05 AM
  7. Concatenate columns with cell data containing Carriage Returns
    By Rob in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2005, 04:05 AM
  8. [SOLVED] Concatenate cells with carriage returns
    By Rob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1