Hey,
I have a data set (column 1) in my spreadsheet. I need to concatenate sequentially an @@1, @@2 and @@3 to the end of the first three entries as seen in column 2. Once the data changes to the next set of numbers (SV1206256002), I need to start the sequence of @@1, @@2 and @@3 over again. Is there a way to do this with autofill \ concatenate or perhaps another way without having to do this manually? Thank you...


SV1206256001 SV1206256001@@1
SV1206256001 SV1206256001@@2
SV1206256001 SV1206256001@@3
SV1206256002 SV1206256002@@1
SV1206256002 SV1206256002@@2
SV1206256002 SV1206256002@@3
SV1206256003
SV1206256003
SV1206256003