# convert textdata file from matrix layout to xyz format

#### gsmpei

##### New Member
Hello all, this is my first post and thank you.

I have a clinical depth data file in the following matrix format.

567
891

I have produced the x-y coordinates on two different sheets, then concatenated the appropriate x- and y- coordinates with the corresponding depth i.e. the "5" would have for example x,y coordinate
-9.5,9.5, the "6" would be -9.5,7.0. This data then goes to a milling machine which requires the data to be in 3 columns (the x and y with the appropriate z).

My method works, but unfortunately my clinical data is never the same size and I end up with rows of cells to delete (hundreds). Is there a way I can manipulate the imported file to be in a 3 column xyz format containing only the data in the matrix?

Grant

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### plettieri

##### Well-known Member
Hi gsmpei:

Welcome to the board

Could you give a specific example of the data you are working with and the expected outcome you desire...while you have started the explaination, it is not totally clear.

plettieri

Replies
3
Views
48
Replies
5
Views
1K
Replies
0
Views
222
Replies
7
Views
5K
Replies
1
Views
883

1,109,359
Messages
5,528,226
Members
409,809
Latest member
VICKRAM

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...