Write data to table

[geoffcodd]

Hi there,

I have the following data

ID	Field1
84	"<font color=""#000080"">MILANO</font>"
88	"<font color=""#000080"">IT</font>"
218	"<font color=""#000080"">LONDON</font>"
222	"<font color=""#000080"">UK</font>"

I need to wite the value in row 84 to column 1 of my table, 88 to column 2 and so on.

What would be the best way to do this?

Thanks
Geoff

 

[geoffcodd]

Hi Pat,

What I am trying to do is sort of transpose the data, as it comes in 4 rows and 1 column, I need to append it too a table with 1 row and 4 columns.

Hope that makes it a little clearer.

Thanks
Geoff

 

[sawebs]

Is there any pattern to your data?
I assume there's more than 4 rows in total!
Simon.