I have a large data set consisting of two columns with repeat row names but unique row values. Here is a small example:
I would like to convert this to a few rows with multiple columns. Like this:Please Login or Register to view this content.
I tried to record a macro, but I could not figure out how to get the macro to not only select the range of cells from B1:B7 but also from B8:B14 when I click on B8. The macro always reverted to B1:7.Please Login or Register to view this content.
Here is my example macro:
Please Login or Register to view this content.
Thank you for your help.
Bookmarks