Combining Rows Based on Matching Fields

[JoshJones55]

Hi All,

Im parsing a txt file with multiple rows that are technically the same overall record. I need to combine the rows based on the columns 1,2,3,4 that have identical fields. Thus if the data in columns 1,2,3, and 4 are an exact match combine the other columns together into 1 row (I.e. Row 1 and 2 would become one row). Please reference below example of the data:

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8	Column 9	Column 10
001	50.00	02/22/23	AAA999	Pass	John
001	50.00	02/22/23	AAA999			NY	USA
001	50.00	02/22/23	BBB999	Fail	Frank
002	25.00	02/22/23	AAA999					Corp	Dev
002	25.00	02/22/23	AAA999	Pass	Bob
003	15.00	02/22/23	BBB999					Corp	Audit
003	15.00	02/22/23	BBB999	Fail	Josh
003	25.00	02/22/23	BBB999	Pass	Mark
003	25.00	02/22/23	BBB999			NC	USA

Thank you in advance!

[BS_THE_ANALYST]

@JoshJones55 here's one way:

[ShankerV · Accepted solution]

Hi @JoshJones55 

One way of doing this more dynamically if in future when there will be more columns in addition.

Many thanks

Shanker V

[Raj]

you can try this as well

[JoshJones55]

Thank you all! Both ways work.