Link to home
Create AccountLog in
Avatar of ExpExchHelp
ExpExchHelpFlag for United States of America

asked on

Challenging Transpose (Excel)

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,
EEH
Transpose.xls
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ExpExchHelp

ASKER

byundt:

As always, you're providing the most excellent solutions!!!

Moving the transpose function to a separate tab should be straight-forward now.

Again, thanks!

EEH