Column data manipulation

[EvansM]

Hello Community,

I need help with manipulating data.  Please see the attached SAMPLE data and EXPECTED RESULTS spreadsheets.  For the accounts with the same Account Numbers, but have a SubType ID of '6',  add a '6' before the account number. Therefore 6+Account Number. (Please see the EXPECTED RESULTS spreadsheet).

Thanks. 

sample data 

expected results 

[Qiu · Accepted solution]

@EvansM 
I hope this would work.

[Tyro_abc · Accepted solution]

Hi @EvansM 

This is my version, let me know if you have any questions.

Regards

Arundhuti

[EvansM]

@Tyro_abc Thanks a lot

[EvansM]

@Qiu Thanks. I think this is going to work.

[Qiu]

@EvansM 
Thank you for the feedback😁