View Single Post
 
Old 06-01-2017, 03:10 PM
madiso10 madiso10 is offline Windows 10 Office 2016
Novice
 
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