How to use only some columns from a row as column headers?
As part of a database export I get a file with some headers that I can use straight away ( from Experiment ID to DOE_FILE_ID) but then I get some 'generic' headers of C1 to C255 what I need to do is to select all of the first row of data which has C1 to C255 as their headers and replace it with the information from the selected first row so C1 would be changed to Sample, C2 would be OLD Sampl...