Transpose Multiple Rows into a Single Row and Randomize in the Same Macro

Hi, new to writing Macros here so I was wondering if someone might be able to give me some tips on the following. I am using Excel 2010 on a Windows 7 PC.

I am trying to get some LMS data where currently a single question takes up 4 rows and the correct answer is always in the first row for each question designated by a 1 in the CORRECT column transposed into a format where each question and its respective possible answers are in the same row and the position of the correct answer is randomized instead of always being in first or (A ) position of a multiple choice answer. At the moment the data looks like the following:

startingformat.jpg

I need it structured like the following where the answer is designated as Correct by either having a TRUE or FALSE next to it in a single row for each questions :
endingformat.jpg
Any help or ideas would be greatly appreciated.

Thanks! Bob

Sure, I think I included it in the original post with the screenshot call endingformat.jpg

Here it is: http://www.excelforum.com/attachment...dingformat.jpg

OK, Sorry about that. Here they are:

Starting Spreadsheet; StartingFormatExample.xlsx

Resulting Format: ResultingFormatExample.xlsx

In each Row, the position of the TRUE value and it's associated answer in the next column to the left should be randomized between across the following columns:

MULTIPLE_ANSWER_1_CORRECT__C MULTIPLE_ANSWER_1__C MULTIPLE_ANSWER_2_CORRECT__C MULTIPLE_ANSWER_2__C MULTIPLE_ANSWER_3_CORRECT__C MULTIPLE_ANSWER_3__C MULTIPLE_ANSWER_4_CORRECT__C MULTIPLE_ANSWER_4__C

Mike,

This is great. I noticed the macro inserted the TRUE or Correct answer into both rows at position 4 or answer 4. Is that because the data set was so small?

Thanks! Bob

Mike,

I ran it with 25 questions and it is completely randomized, it works great!

Thank you so much!

Regards, Bob