copy data with updated data

Copper Contributor

Hi all, I need help with Excel. I have a column called Tracking number with 10,000 rows; how can I duplicate the 10,000 records by adding one or something else at the end of each row? For instance, I have 13EAF7 in my cell, and when it gets copied, it should be 13EAF71

1 Reply

@Harris0261 Well 10K rows isn't all that much, so I would go for the simplest of solutions that works in all Excel versions on all platforms. Let's say the first code is in A1, then enter the following in B1 and copy it all the way down.

 

=A1&"1"

 

Then, copy the entire column B and paste onto itself as values to get rid of the formulas.