Transpose columns to rows with spaces
Thank you for the formula it really helped. I have one more quick ?...now
that I have the data in the format that I want, how can I copy it to another
worksheet for sorting, moving, ect.? Since the cells are referencing the "A"
column, I am not able to work with the data. I really appreciate your help.
It's saving me a massive amount of time.
"Gary''s Student" wrote:
If you data is in column A then in B1 enter:
=INDIRECT("A" & ROW()*4-5+COLUMN())
then copy this formula down columns B, C, and D
--
Gary''s Student - gsnu200713
|