Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 11:22 PM.


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