my spreadsheet has duplicate serial numbers in column A and the corresponding row in column B has mutliple descriptions for the same serial number. I need to combine those descriptions into 1 cell rather than having multiple rows for the same serial number. is there an IF formula that I can combine with a concatenate that will capture what I need?
See if the following helps.
Assuming your data begins in row #2,
in cell C2 enter the formula
and in cell D2 enter the formula
Please Login or Register to view this content.
and copy the formulas down to the end of your data.Please Login or Register to view this content.
For this clean-up task, you keep the rows that contain descriptions in column D
after copying and pasting column D formulas as values.
View the attached Excel file to see how this works.
Last edited by xLJer; 02-28-2014 at 04:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks