Hello,
I have a table with data imported from an excel spreadsheet via DTS..
some rows are:
and i need them to be:
what is the easiest way i can achieve this? so i can go start looking it up
id like to incorporate it into my DTS package if possible...
thank you
I have a table with data imported from an excel spreadsheet via DTS..
some rows are:
Code:
|name | place | cost | hours|
| x | y | a | b |
and i need them to be:
Code:
|name | place | value|
| x | y | a |
| x | y | b |
what is the easiest way i can achieve this? so i can go start looking it up
id like to incorporate it into my DTS package if possible...
thank you