How to use only some columns from a row as column headers?

Question

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 Sample Identifier etc. For every table I get this information will be different so I can't use a Find & Replace to do this.I cannot change the way that this data is imported using preferences as it is from a database.

Many regards

David

attachFile

Jeff_Perkinson · Accepted Answer

If you're okay doing it interactively, you can use copy and paste.

Select the cells in the first row that have the column names. Then select the columns in the columns panel on the left and paste them.

See this blog post for a more complete explanation, with a video.

-Jeff

stan_koprowski · Accepted Answer

Another option is to use the Column Names Utility Addin.

Select the columns you want to move up and then click move up.

Best,

Stan