OK it sounds silly but I have a 152 rows to 28 columns worksheet full of data that I want to turn it into 28 rows to 152 columns. I think you call that "matrix transposing". I tried to find out how the transpose function works but (silly me) all my attempts went wrong.
I can sit down and program it but there must be a way to do it in Excel.
NE help appreciated
I can sit down and program it but there must be a way to do it in Excel.
NE help appreciated