legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,214
- Office Version
- 365
- Platform
- Windows
Hi,
I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For example:
Name...….....ID...……...Address
Joe Smith....123...……..25 Apple Dr.
Joe Smith.....123...…...New York City, NY, 00972
Sue Brown....445...…...90 Bayview St. Miami, FL 32423
Tim Rice...….565...…..55 Pachino St.
Tim Rice...…..565...….Rockville, MD 64310
ExpectedResult:
Joe Smith...….123......25 Apple Dr. New York City, NY, 00972
Sue Brown....445...…...90 Bayview St. Miami, FL 32423
Tim Rice...….565...…..55 Pachino St. Rockville, MD 64310
How can I transform my data to show like this?
I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For example:
Name...….....ID...……...Address
Joe Smith....123...……..25 Apple Dr.
Joe Smith.....123...…...New York City, NY, 00972
Sue Brown....445...…...90 Bayview St. Miami, FL 32423
Tim Rice...….565...…..55 Pachino St.
Tim Rice...…..565...….Rockville, MD 64310
ExpectedResult:
Joe Smith...….123......25 Apple Dr. New York City, NY, 00972
Sue Brown....445...…...90 Bayview St. Miami, FL 32423
Tim Rice...….565...…..55 Pachino St. Rockville, MD 64310
How can I transform my data to show like this?
Last edited: