Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2017, 03:10 PM
madiso10 madiso10 is offline Field has multiple values how get those multiple values into one row Windows 10 Field has multiple values how get those multiple values into one row Office 2016
Novice
Field has multiple values how get those multiple values into one row
 
Join Date: Jun 2017
Posts: 1
madiso10 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-02-2017, 04:48 AM
NBVC's Avatar
NBVC NBVC is offline Field has multiple values how get those multiple values into one row Windows 7 64bit Field has multiple values how get those multiple values into one row Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote
Reply

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
Field has multiple values how get those multiple values into one row IF Formula - multiple values Jac_Fcb Excel 1 03-17-2015 12:41 AM
Field has multiple values how get those multiple values into one row 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
Field has multiple values how get those multiple values into one row VLookup multiple values and Sum tinfanide Excel 2 09-02-2014 11:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft