Is there an easy way to...

J

JCL

I need data in X,Y,Z format for my mapping/gridding program.

However, my excel spreadsheet I use to calculate the data gives m
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 takin
forever!

Many thanks in advance
 
D

Daniel CHEN

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
=================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

% of Subtotal in PivotTable 2
Average a group, where grouping is Conditional on other col.??? 1
% of subtotal in pivot table 1
Complicated value lookup 10
Easy VB code question 2
Scrabble Value calculation for Welsh words 0
How Do you send results of calc to seperate rows of answers to then later create chart 4
PivotTable - Percent of Current Total 1

Top