Hi,
in the attached .txt. file I'm trying to transpose the values starting by '!' from the row they are to a new column, repeating the same value until the next row starting.
The delimiter is ';'.
I think is a very common case of became row values into fileds but I'm not able with the wizard.
I hop the attached files are clair enough.
Thanks