I have a spread sheet have 300 columns. Some columns have same heading as"Category". I like to copy all the information in one column "Category" without changing the row location. Example:
Test1 Category Test2 Category
Thanks for the help.