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