Forum Discussion

Harris0261's avatar
Harris0261
Copper Contributor
Dec 04, 2023

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 have 13EAF7 in my cell, and when it gets copied, it should be 13EAF71

excel

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 04, 2023

    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. 

Resources