View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default table to xyz list

I have a worksheet like this:

200 201 202 203
199 5.8 5.7 5.6 5.6
198 6 6.2 6.1 5.8
197 6 5.5 5.6 5.3
196 5.6 0 0 0

The header row goes all the way to 299, and the first column goes from
199 to 1. What I need is an xyz style list that I can import into
mapinfo, how can I do this?

What I want is something like this:

199 200 5.8
199 201 5.7
199 202 5.6
199 203 5.6
198 200 6
198 201 6.2
198 202 6.1
198 203 5.8
197 200 6
197 201 5.5
197 202 5.6
197 203 5.3
196 200 5.6
196 201 0
196 202 0
196 202 0

Can anyone help me?