Hi,
I have x, y, z under column A.
And 1, 2, 3 under column B.
I would like to have a new list which will look like:
C D (columns)
x 1
x 2
x 3
y 1
y 2
y 3
z 1
z 2
z 3
How can I do it?
Best regards
Hi,
I have x, y, z under column A.
And 1, 2, 3 under column B.
I would like to have a new list which will look like:
C D (columns)
x 1
x 2
x 3
y 1
y 2
y 3
z 1
z 2
z 3
How can I do it?
Best regards
I have got it for you the VBA way. Use this code -Press Alt+F11 on your file. It will open up a blank code window. On the left hand side, you will find Microsoft Excel Objects. Right click on it and select Insert-> Module. Copy the code over. Go back to your excel sheet. Select Tools->Macro-> Macros and run the macro available.Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks