Put this into Cell F2 and then copy it down
=CONCATENATE(B2," ",C2," ",D2," ",E2)
<------Please click the star if this helped you!
Put this into Cell F2 and then copy it down
=CONCATENATE(B2," ",C2," ",D2," ",E2)
<------Please click the star if this helped you!
http://excelevangelist.blogspot.com/
Your not looking at my attached file, I can add the year make model together, look at the attached file, and you will get the idea, based off the value in column A, I want to combine the vehicles separated by a comma in one line.
This forumula is dependent on having column A sorted, like you have it in the sample.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks