Good Morning
I need help because I am trying to transpose the following values, just like the attached file.
I've tried with matrix formula, but I can not get what I want.
Good Morning
I need help because I am trying to transpose the following values, just like the attached file.
I've tried with matrix formula, but I can not get what I want.
Last edited by Birnen; 01-19-2017 at 12:29 PM.
in J4
=INDEX($B$4:$F$9,(ROW()-4)*2+1,COLUMN()-9)
copy across and down to N6
in P4
=INDEX($B$4:$F$9,(ROW()-4)*2+2,COLUMN()-15)
copy across and down to T11
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
j4and copy acrossPlease Login or Register to view this content.
p4and copy acrossPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks