I have a spreadsheet that has duplicates in column a. Then the other columns have different data that goes with them. I would like to combine so that I have a unique number is column a and have the other columns showing all of the data.
For example
SO name type
1023 jake 24/7
1023 jake premium
1024 brian premium
I would like it to look like this.
SO name type type
1023 jake 24/7 premium
1024 brian premium
Does anyone know how to do this with functions?
Please post a sample workbook with what is typically found in each column, and the expected result.
Pete
What version of Excel are you using?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Simple/stupid solution (-'s included for reading clarity):
--A----B------C------------D
1023--Jake -24/7 -------1023Jake24/7---------------------------->First line formula: =A1&B1&C1
1023--Jake -Premium-- 1023Jake24/7Premium------------------>Copy down for all other lines: '=IF(B2=B1,D1&C2,A2&B2&C2)
1024--Brian-Premium--1024BrianPremium
Last edited by ccarnesva; 12-05-2015 at 12:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks