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

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

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

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