I have a file with multiple values that I need to combine on one line. For instance, I have a unique ID on multiple rows that need to be combined into one row. Current format ID Serial NumberInstall Date123AB1121/2/2019123AB1116/5/2018 Desired Format IDSerial Number 1Install Date #1Serial Number 2Install Date #2123AB1121/2/2019AB1116/5/2018 *Note: The original file contains more than 20 columns but I only need information from a few of the columns. Any help would be much appreciated!

Multiple rows with unique ID, need to pull information in one row by ID

I have a file with multiple values that I need to combine on one line. For instance, I have a unique ID on multiple rows that need to be combined into one row.

Current format
ID	Serial Number	Install Date
123	AB112	1/2/2019
123	AB111	6/5/2018

Desired Format
ID	Serial Number 1	Install Date #1	Serial Number 2	Install Date #2
123	AB112	1/2/2019	AB111	6/5/2018

*Note: The original file contains more than 20 columns but I only need information from a few of the columns.

Any help would be much appreciated!

Developer

Reporting

Connectors

Expression

Accepted answers

BrandonB

Example solution attached

Example Solution picture.png

Example Solution.yxmd

All comments

BrandonB

Example solution attached

Example Solution picture.png

Example Solution.yxmd

ctk

Thanks! I'm just getting caught up at the formula. For example, I've input [Name]+"Serial Number"+ToString([RecordID]) and get the error The field "" is not contained in the record (Expression #1)

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335