Forum Discussion
JPL123
Nov 12, 2024Copper Contributor
how to transpose multiple columns into 1
I have a data in a 7 day week by week format
I need to transpose this so it show's like it is in J. i.e each day going down a single column
Is there a formula that can do this?
1 Reply
- SergeiBaklanDiamond Contributor
As variant
=TOCOL(B3:H6,1)