LinkBack URL
About LinkBacks
Hi friends
is there any simple formular to copy data from horizontal to vertically apart from transpose?
I have data in cell A1 to D1
i want to copy in cell E2 to E6
i hope i will get assistance from any experts
Hi friends
is there any simple formular to copy data from horizontal to vertically apart from transpose?
I have data in cell A1 to D1
i want to copy in cell E2 to E6
i hope i will get assistance from any experts
Something like this?
aa bb cc dd aa bb cc dd
E2=IFERROR(INDEX($A$1:$D$1,,ROWS($A$1:A1)),"")
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks