Need help with a macro to copy rows into two columns, ignoring empty cells.

Hi,

I have a list of questions in a spreadsheet, where each row consists of a question, up to 5 possible answers, and a correct answer.

table1.jpg

I'm trying to make a macro which will copy each row and paste it into two columns, where each question is separated by an empty row. I'd like it to ignore empty cells, for example if there are only two option answers it won't show the empty cells for Options C, D and E.

table2.jpg

If anyone could help I'd be really grateful! Thanks.

Give this a try:

Please Login or Register  to view this content.

Works beautifully, many thanks!