View Single Post
 
Old 12-09-2011, 12:05 PM
niuri_cigarete niuri_cigarete is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2011
Location: Vilnius
Posts: 2
niuri_cigarete is on a distinguished road
Default Converting data-table into coding text

Hey everyone,

I've ran into this problem and can't seem to find an easy and fast solution. I have a large amount of data stored in table such as this:


I need to rewrite or convert it to a code where each data line would look like this:

<measure>
<observation-time>2011-02-10T00:15Z</observation-time>
<at>-4.5</at>
<td>-11</td>
<pi>1</pi>
<ws>1.7</ws>
<sc>33</sc>
<st>-3.3</st>
<sst>-0.9</sst>
</measure>

Any ideas how can I do this in an easy and fast way? I'm familiar with macros but I'm only at a beginner level.

I would really appreciate the help!
Reply With Quote