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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table to xyz list
Try this: A2 = 199 A3 = 198 B1 = 200 C1 = 201 D1 = 202 E1 = 203 B2 = 5.8 C2 = 5.7 D2 = 5.6 E2 = 5.6 B3 = 6 C3 = 6.2 D3 = 6.1 E3 = 5.8 G1 = =OFFSET(A$1,ROUNDUP(CELL("row",A1)/4,0),0 H1 = =OFFSET($A$1,0,IF(MOD(CELL("row",A1),4)=0,4,MOD(CE LL("row",A1),4))) I1 = =OFFSET($A$1,ROUNDUP(CELL("row",F1)/4,0),IF(MOD(CELL("row",A1),4)=0,4,MOD(CELL("row",A 1),4))) -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=548230 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table to xyz list
CaptainQuattro <-- Excelent job :-) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table to xyz list
Thank you very much, it worked perfectly.
|
Reply |
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 |