Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easy way to...
I need data in X,Y,Z format for my mapping/gridding program. However, my excel spreadsheet I use to calculate the data gives me results in table form ie: ..XXXXX YZZZZZ YZZZZZ YZZZZZ Is there an easy way to convert that to a "list" format (X,Y,Z). At the moment I'm having to ref it all by hand and it is taking forever! Many thanks in advance. -- JCL ------------------------------------------------------------------------ JCL's Profile: http://www.excelforum.com/member.php...o&userid=34748 View this thread: http://www.excelforum.com/showthread...hreadid=547092 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easy way to...
Need more explanation.
Definitely there is any easy way. Please send me the file and be more clear about what you want. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "JCL" wrote in message ... I need data in X,Y,Z format for my mapping/gridding program. However, my excel spreadsheet I use to calculate the data gives me results in table form ie: .XXXXX YZZZZZ YZZZZZ YZZZZZ Is there an easy way to convert that to a "list" format (X,Y,Z). At the moment I'm having to ref it all by hand and it is taking forever! Many thanks in advance. -- JCL ------------------------------------------------------------------------ JCL's Profile: http://www.excelforum.com/member.php...o&userid=34748 View this thread: http://www.excelforum.com/showthread...hreadid=547092 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easy way to...
JCL,
John Walkenbach describes how to do this on his web-site he http://www.j-walk.com/ss/excel/usertips/tip068.htm HTH "JCL" wrote: I need data in X,Y,Z format for my mapping/gridding program. However, my excel spreadsheet I use to calculate the data gives me results in table form ie: ..XXXXX YZZZZZ YZZZZZ YZZZZZ Is there an easy way to convert that to a "list" format (X,Y,Z). At the moment I'm having to ref it all by hand and it is taking forever! Many thanks in advance. -- JCL ------------------------------------------------------------------------ JCL's Profile: http://www.excelforum.com/member.php...o&userid=34748 View this thread: http://www.excelforum.com/showthread...hreadid=547092 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an easy way to...
wonderful, many thanks. -- JCL ------------------------------------------------------------------------ JCL's Profile: http://www.excelforum.com/member.php...o&userid=34748 View this thread: http://www.excelforum.com/showthread...hreadid=547092 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easy way to delete all rows with no text in them? | New Users to Excel | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel |