Part Number | Description | Qty1 | Cost1 | OEM Resale1 | Qty2 | Cost2| Resale2
I would like to have them in separate columns. I'm using phpmyadmin to write my querys. Is this at all possible? The best i've seen is the concat function which once i get past description would put all remaining data into one field that has been comma separated. I could do that and transfer back to excel.
I ask as the file that I'm using is 30K+ rows and the coworker i'm setting this up for gets this file in the same format to evaluate about 5 times a year