Hi,
Can any one solve the following.
For Ex:- Jim Jack Jill Janet
Jullian John Jony Jackee
Result : {=Transpose(Array)
Jim
Jack
Jill
Janet
Jullian
John
Jony
Jackee
Hi,
Can any one solve the following.
For Ex:- Jim Jack Jill Janet
Jullian John Jony Jackee
Result : {=Transpose(Array)
Jim
Jack
Jill
Janet
Jullian
John
Jony
Jackee
Is this what you wanted (assumes data in A1 to F1). Drag down.
=INDEX($A$1:$F$1,ROW(A1))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glenn,
Its not working , Please find the attachment.
Sorry. On a small screen, I thought everything was in a single row.
Try this array-entered formula. if your real output does NOT start in row 7, replace the 2 7s with the actual stating output row.
I forgot to add, change the 2 5's to the number of columns in your real sheet array.
Thanks Glenn,
It has been working
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks