• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help in Formula Type

cipher

New Member
Hello Everyone,

Need help for my excel file i'm working on right now.
1_zps2a772992.png


As you can see, there are 5 columns in there: Link, 2G ID, 3G ID, SiteName, Routepath
Each Link can contain up to 2-20 data of 2G ID, 3G ID.
Example

2_zpsfa0ba06a.png


I want to format the data to be like this one
(Just say i just want a 3 ID's for each link)

4_zps682b441f.png

So each row, the Link will show multiple ID's sitename ans routepath. (The Links will be a unique data)

How do i do that using formulas or other functionality in Excel?
Because to manually copy paste takes a lot of time :( (It have 6000 Links)

Can you guys show me how to do it, i mean steps by steps ?
or maybe you can do it for me in the file given, and reupload it again to me? it will be veryyy helpful hehe:) (I'm still new in excel worlds)

Thanks in Advance
and please pardon my english :confused:
 

Attachments

  • File 1.xlsx
    462.1 KB · Views: 2
Hi Ciper,

My initial guess, such data layout change if done through formula will slow down the whole workbook. Consider the LINK Cyber1 with 205 values.

I would suggest the use of VBA in this. Are you OK with that?

Regards,
 
Hi Cipher, Cant see the images...can you share the example for row no 2 as per your excel..
Hi Asheesh
maybe you can use this link ?
http://i1373.photobucket.com/albums/ag362/cipherism/1_zps2a772992.png
http://i1373.photobucket.com/albums/ag362/cipherism/2_zpsfa0ba06a.png
http://i1373.photobucket.com/albums/ag362/cipherism/4_zps682b441f.png

Hi Ciper,

My initial guess, such data layout change if done through formula will slow down the whole workbook. Consider the LINK Cyber1 with 205 values.

I would suggest the use of VBA in this. Are you OK with that?

Regards,
Hi Somendra

VBA it's okay, anything to make this work :DD
 
Back
Top