LinkBack URL
About LinkBacks
Hi folks..
here is the situation..
I want data in multiple columns into only one column... using excel general formula... No Vba is required..?
any help would be appreciated..
Check the attachment...
Thanks in advance...
Hi folks..
here is the situation..
I want data in multiple columns into only one column... using excel general formula... No Vba is required..?
any help would be appreciated..
Check the attachment...
Thanks in advance...
Is that data that you have put data in matrix format you need in single column itself. Please check and let me know.
I want the date in matrix format in single column.. in 1st Question..
Thanks you for reply..
I think its first time that OP is solving his own threads...
The solution is
Formula:
Please Login or Register to view this content.
If there is any alternative then I will be glad to know...
Don't forget to click *
=INDEX($C$3:$F$5,MOD(ROWS(A$1:A1)-1,ROWS($C$3:$F$5))+1,INT((ROWS(A$1:A1)-1)/ROWS($C$3:$F$5))+1)
and copied down as necessary
Oh I got it...
Try this one
=CHAR(SMALL(IF($C$3:$F$5<>"",CODE($C$3:$F$5)),ROWS($A$1:A1)))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks