|
Registered
Join Date: Jul 2001
Location: Lawrenceville GA 30045
Posts: 7,455
|
I've just tried a method and it will get you close to your result wanted:
I'll explain the steps:
1 - insert a column before column B
2 - enter a formula in B2 - use the concatenate function to merge the part numbers and their descriptions =CONCATENATE("P/N ", C2, " DESC: ",D2)
3 - autofilter the column headings
4 - filter on 911
5 - highlight all entries in column B and COPY
6 - move to the new location where you want the data and in column A enter 911
7 - on that same row, column B, select Paste -Special, Values only, Transponse
repeat 5 through 7 for each "type" you have
__________________
Mark
'83 SC Targa - since 5/5/2001
'06 911 S Aerokit - from 5/2/2016 to 11/14/2018
'11 911 S w/PDK - from 7/2/2021 to ???
|