moving data based on text, possible IF formula

**tompixc** · 03-03-2015, 12:51 PM

It is kind of hard to explain, but I have data in a spreadsheet, it contains a code known as an SKU in one column, then the next corresponds another code linked to that which is an ASIN, however in this list several ASINs are for one SKU but each ASIN is on its own, I want to get the ASINs that apply to a SKU on that one row, so the first goes in B then C then D etc, I figured a simple IF formula would work but am not sure, i'm not an advanced Excel user.

Any thoughts, advice or links if possible would be greatly appreciated. If this is in the wrong place I apologise, I wasn't 100% sure if it would be best in here or not.

**walruseggman** · 03-03-2015, 12:59 PM

Can you provide an example of how the SKUs and ASINs are formatted, please? For example, is there a SKU on every line, or is there a a SKU at the first ASIN, and then blank cells until the next SKU?

**tompixc** · 03-04-2015, 05:03 AM

Thanks for the quick reply, there is an SKU on every row, sometimes it is the same SKU, hence if it is the same SKU we want it to add the ASIN to the row that already has an SKU and ASIN, hope this makes sense. As it happens a solution appears to have been found, seems I was beaten to it, thanks for your time and help!

this is the formula my line manager worked out in case anyone finds this post and wonders how it is solved.

=INDEX($B$2:$B$21441, SMALL(IF($A21445=$A$2:$A$21441, ROW($A$2:$A$21441)-ROW($A$2)+1), COLUMN(A1)))

**sourabhg98** · 03-04-2015, 05:13 AM

attach a sample workbook (after deleting confidential data) and manually write down the results you need..

moving data based on text, possible IF formula

LinkBack

Thread Tools

Rate This Thread

Display

moving data based on text, possible IF formula

Re: moving data based on text, possible IF formula

Re: moving data based on text, possible IF formula

Re: moving data based on text, possible IF formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Moving text with excel formula

[SOLVED] Excel 2007 : Moving a Range Based on Variable Text Value

Moving data based on If

VB - Moving data based on If

Obtaining cell-based data from a moving trendline? Predicting data question!

Bookmarks

Bookmarks

Posting Permissions