Is it possible to copy multiple column names from one table and paste them on another without bringing along their properties or values?Say you have table A with n-columns and their rows are populated with values (formula or not). Then, you want to copy the names of these n-columns from table A to be able to paste them on table B - also with n-columns and with rows populated with values (formula or not). The caveat is that table B rows are already populated with values that are different than those of table A and you want to keep them after you paste the new column names - you don't want to bring along Table A column values or formulas. As a result, you want the two tables to have the same column names and keep their original values (formula or not) intact.
Re: Is it possible to copy multiple column names from one table and paste them on another without bringing along their properties or values?Yes, absolutely it's possible.
You need to use the columns list on the left side to copy the column names. Check out Column Names Got You Down? Try This. for the trick.
