I have a number of worksheets (n=202) which contain two columns of data, the first column is integers of density and the second a pixel count from an image. I would like to consolidate these columns into one single worksheet by column, but only including the integers in the first column and the pixel counts with the corresponding worksheet number as a header as the continuous following columns.
I have an add in for excel which will combine worksheets (kutools) but this combines the data rows so that data is on top of one another and I need it as columns so I can plot the results.
I have attached an example of the simple data file containing an example of the first ten worksheets if that helps
Bookmarks