| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup? list data into summary table | Excel Worksheet Functions | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
| How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
Threaded Mode
