Hello,
I have a XLSX file of my products list, there are 3959 parts total. They go like this
Column A
07 11 9 900 250
07 11 9 900 673
07 11 9 901 294
07 11 9 901 438.. so on
What i want to do is leave the existing as they are however add 3 more rows for each product like so..
07 11 9 900 250
07 11 9 900 250-E
07 11 9 900 250-G
07 11 9 900 250-T
07 11 9 900 673
07 11 9 900 673-E
07 11 9 900 673-G
07 11 9 900 673-T
07 11 9 901 294
07 11 9 901 294-E
07 11 9 901 294-G
07 11 9 901 294-T.. so o
TO import them into Peachtree, However i m not able to use autofill as i m not familiar with macros or anything advanced in excel.
So tell me if theres a formula or a autofill macro or anything tht can solve this.
So the main goal is to add a letters after every part number thrice (E, G & T)
Really appreciate any help,
Plz post if u need the files .
FYI: I m using Excel 2007 and have to make this edit in xlsx file and later copy it into a CSV file to be imported into Peachtree
