Hey People...My first post here..
I am looking to concatenate column wise data to get all the combination.
A small example of what I am looking for..
Consider this table..
a p x b q y c q z
I want to concatenate as follows..
apx,apy,apz,aqx,aqy,aqz.arx.ary.arz
bpx,bpy,bpz,bqx,bqy,bqz,brx,bry,brz
cpx,cpy,cpz,cqz,cqy,cqz,crx,cry,crz.
I have data numbers in 100s to do the same.
Thanks in Advance....
Copy and paste the below UDF code in Standard Mudule.
=getdata(First_Column_Cell,Second_Column_Range,Third_Column_Range)
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Refer the attached file for details.
Hope this helps!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks a lot sir.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks