Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel |