Hi All,
Kindly advise how to arrange the vendor region details in a single line using excel function.
Thanks in advance for your help.
Hi All,
Kindly advise how to arrange the vendor region details in a single line using excel function.
Thanks in advance for your help.
will your data always be sorted as it is - the first valid region ID will always be in West, then North, then South (as applicable)?
assuming so, i've accomplished the desired result in G3:J9 in the attached with the following formulas:
Formula:Please Login or Register to view this content.
array formula (ctrl+shift enter)
Formula:Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
this is matching my requirements. Thanks a lot
glad to hear it, thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks