Forum Discussion
Convert list of data to table
Hello everyone, I have a data set of this form: Author Author1 Title Title1 Date Date1 Author Author2 Title Title2 Date Date2 Author Author3 Title Title3 Date ...
Thanks for your help. I have to say that I am a mere beginner. How do I run this code ?
diegohoutart You can right-click any sheet tab, select View Code, which will open the Visual Basic Editor (VBE). Then go to Insert > Module, and paste the code in the new window that opens on the right. Alt+Q will exit you back to Excel. You can run the code by selecting it from the Macros pane (Alt+T+M+M), then press Run. You can also run it from the https://support.office.com/en-us/article/Show-the-Developer-tab-E1192344-5E56-4D45-931B-E5FD9BEA2D45 > Macros.
Sergei - That's a great solution. I had thought about doing it with PQ, but didn't even think of using an Index & divisor.