#1
|
|||
|
|||
Field has multiple values how get those multiple values into one row
It have part numbers and multiple values for these part numbers. how do I get these values into the same row for the part numbers that correspond to them instead of a list one under each other. Is this possible in Excel?
Part number | Product File name | Product Filename | Product Filename I am using Excel 2016. I have attached an example of the excel spreadsheet. Some part numbers have 1-3 filenames associated with it. This is an example of the excel file I have: partNumber Images filename TNN608679 9ccc7f3188014fd185049edcdcfc3759.1.png TNN608679 9ccc7f3188014fd185049edcdcfc3759.2.png TNN608679 9ccc7f3188014fd185049edcdcfc3759.3.png ATSZ-1401A 38cba2e6d3244a088477e31c1499a9ff.1.png ATSZ-1401A 38cba2e6d3244a088477e31c1499a9ff.2.png EAGN509-0239 38cbc66a92de4db687c475ad784d7257.1.png EAGN509-0239 38cbc66a92de4db687c475ad784d7257.2.png AMT121116-13 39da43a85f46400fbea3e339e866420b.1.png AMT121116-13 39da43a85f46400fbea3e339e866420b.2.png AML61679A 41423806be434b3bb34299a6cffcbb94.1.png AML61679A 41423806be434b3bb34299a6cffcbb94.2.png AML61679A 41423806be434b3bb34299a6cffcbb94.3.png CKE56314538 83f3352df2434409bbc33d5ab6e687d7.1.png CKE56314538 83f3352df2434409bbc33d5ab6e687d7.2.png CKE56314538 83f3352df2434409bbc33d5ab6e687d7.3.png TNN222384TG 3ca11ebf6b80491cb282de2928f96b72.1.png TNN222384TG 3ca11ebf6b80491cb282de2928f96b72.2.png ADV56413761 38fd9962132d465da8cbcb317c1e7a1e.1.png ADV56413761 38fd9962132d465da8cbcb317c1e7a1e.2.png ADV56413762 dd376f13340f475599b1b3631bfb40c4.1.png ADV56413762 dd376f13340f475599b1b3631bfb40c4.2.png ADV56413766 d56d401af00f48c99afe02b02add4623.1.png ADV56413766 d56d401af00f48c99afe02b02add4623.2.png Thank you in advance, Lee Harris |
#2
|
||||
|
||||
First extract the unique part numbers, using Advanced Filter (Data Menu) to another area, say column F.
Once you have the unique parts in Column F, then in G2 enter formula: =IFERROR(INDEX($B$2:$B$24,SMALL(IF($A$2:$A$24=$F2, ROW($A$2:$A$24)-MIN(ROW($A$2:$A$24))+1),COLUMNS($G1:G1))),"") Adjust ranges to suit (don't use ranges larger than necessary). Then confirm the formula with CTRL+SHIFT+ENTER not just ENTER. Copied down and across as far as needed to get all the data. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
IF Formula - multiple values | Jac_Fcb | Excel | 1 | 03-17-2015 12:41 AM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
VLookup multiple values and Sum | tinfanide | Excel | 2 | 09-02-2014 11:41 AM |