I have a strange text file that contains values separated by a 2 character abbreviation. ie. "PN" and "QT" I can import just fine, but I can't seem to get the data to separate into separate columns.
This is what the text file looks like.
PN=DSAI6612
QT=3
PN=CT22L
QT=3
after I import and filter through a query it looks like
Field1 |
Field2 |
PN |
DSAI6612 |
QT |
3 |
PN |
CT22L |
QT |
3 |
Problem is, I need it to look like this
Field1 |
Field2 |
DSAI6612 |
3 |
CT22L |
3 |
I don't know what I'm missing.
Please help!!
Thank you in advance