I am getting an excel file from a client that consists of multiple 'descriptor' columns (sample date, received date, project number, sample number, lab name, etc), and then multiple columns for each sample value (i.e. pH in column M, EC in column N, etc.). The problem is that the client will put one value per row - so in row 162 they will have all the descriptor information and a value in column M. Then in row 163 they have the same descriptor information and have a value in column N. The whole document is currently about 40 000 rows long (...), and rather than deal with the data in this way we need a way to consolidate the data so that each sample has all its values in the same row. The problem is the multiple descriptor rows - I haven't been able to find a way to consolidate the data that allows me to choose multiple columns to say the same - help?