Is there an easy way to...

  • Thread starter Thread starter JCL
  • Start date Start date
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
 
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

CONDITIONAL SUM ("OR") 14
Scrabble Value calculation for Welsh words 0
Errors in simple sum function 1
Average a group, where grouping is Conditional on other col.??? 1
% of subtotal in pivot table 1
array or IF formula excel help 2
Link to excel table which has keys in both row and col headers: isthis possible? 0
% of Subtotal in PivotTable 2

Back
Top