ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Format (https://www.excelbanter.com/excel-discussion-misc-queries/181269-data-format.html)

Harold

Data Format
 
I have a typical x/y plane with data at each location, I am trying to convert
this information from that form into 3 columns. The first column is to be the
x values, the second the y values and the third is to be the data at the
intersection of the x/y points. I have no idea how to do this and have been
writing a macro but I have so much data that I am going to end up writing
around 20 macros because of the size. Does anyone know of an easier way?


All times are GMT +1. The time now is 02:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com