Forum Discussion
copy data with updated data
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...
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.