Hello. I have a problem I need to resolve.
I have 2 worksheets with data. (aprox 40 columns each)
The names of the columns are 1-a 2-a 3-a 4-a 5-a, etc... on one of the worksheets and 1-b, 2-b, 3-b, 4-b, etc... on the other worksheet. What I need to do is a new worksheet with columns combining the data of each of the worksheets . I mean I need a new worksheet with this information order
1-a, 1-b, 2-a, 2-b, 3-a, 3-b, etc... (I would like to get a quick solution, no just copy and paste because the data base is so big, so it takes a lof of time)
Any suggestion?
I really appreciate you help..