Hello Everyone,
Need help for my excel file i'm working on right now.
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
I want to format the data to be like this one
(Just say i just want a 3 ID's for each link)
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
Need help for my excel file i'm working on right now.
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
I want to format the data to be like this one
(Just say i just want a 3 ID's for each link)
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