Hello Excelites, I need to copy information from every other column into a format where it is displayed sequentially. I have tried using the index as well as offset commands and just can't get it to work. Can someone help me out?
Example: information is located in cells C5,C7,C9, etc. I need to put the information in B15,B16,B17, etc.
Many thanks!
Example: information is located in cells C5,C7,C9, etc. I need to put the information in B15,B16,B17, etc.
Many thanks!