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
Bookmarks