Does any one know how to combine data points from multiple rows into a single Row. See example attached
Does any one know how to combine data points from multiple rows into a single Row. See example attached
=INDEX($B$3:$D$8,(ROW(B13)-ROW(B$13))*3+COLUMN(B13)-COLUMN($B13)+1,COLUMN(B13)-COLUMN($B13)+1)
in B13 filled across to D13 then down to D14 is one way.
Beau Nydal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks