I have a matrix which I have extracted from an Excel file that contains [row_location, column_location, data]. The row and column are non conituous, so the matrix looks like this:
  [0.1981]
  [0.2209]
  [0.2276]
  [0.2276]
  [0.2773]
  [0.3941]
  [0.3256]
  [0.3135]
  [0.2343]
  [0.3337]
I know how big the full matrix would be from
MaxRow = max(ExtractedData(:, 1))
MaxCol = max(ExtractedData(:, 2))
So I create a NaN matrix of the size
DataToPlot = NaN(MaxRow MaxCol)
& then I would like to populate the correct entry in the DataToPlot matrix with the data from the spreadsheet i.e.
DataToPlot(8, 93) = 0.1981
DataToPlot(8, 94) = 0.2209
DataToPlot(8, 95) = 0.2276
I can see that I want to use a loop to step through the ExtractedData one row at a time, but then I'm unsure of how to extract & use the index data to populate the correct location with the data.
The end goal is to generate a surface plot of the data so if there are any shortcuts or 'best practice' ways of going from extacted data to surface plot I'd appreciate a steer in the right direction.