I need some help with automating (maybe via macro) a "2-step transpose" function.
Please see attached XLS for details. I've highlighted the cells that need to be transposed AND realigned.
The rows are indicative of a survey response. Right now, I have 3 test surveys; however, that number will grow.
Once transposed, the columns will be remain at four. So, a 4th user would populate cell range F49:J59.
The data shown is cell range F13:J47 (for 3 users) is the desired final product. The data shown as step #1 (A13:D59) does NOT need to be displayed. (It's merely included for illustrating the current manual process).
Does anyone know how to automate this process? I'd prefer to NOT just use cell reference and keep copying them down. Instead, I'd like to select the cell range of survey participants and then, e.g., run a macro to perform the transpose/realign functions.
Thanks in advance,