HOW TO GET DESIRED OUTCOME USING EXCEL?

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one.

Here’s the problem, i’ve been testing out some formulas to see if i can produce my desired result of table of data but to no avail. Heres what i want to happen.

Using this table: Desired result:

1 aa 881 1 aa 881

2 ab 882 2 ab 883

2 ab 883 3 ac 884

3 ac 884 4 ad 886

4 ad 885 5 ae 889

4 ad 886

5 ae 887

5 ae 888

5 ae 889

 

It’s not really the table i’m working on, but it shows the idea of what i want to happen. 

The numbers can get up to as high as 500+, with some numbers not only having a duplicate but also a triplicate. 

Thanks for reading this. Hope to have a generous answer from anyone here.

By: GeDeon

473 thoughts on “HOW TO GET DESIRED OUTCOME USING EXCEL?

  1. Aplicativo Ver Futebol Ao Vivo

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. Huruf Timbul Jakarta

    Do a person mind if I offer a couple of the posts as long since I provide credit in addition to sources back to your own blog? My blog is usually in the same specific niche market as yours, and the users would benefit by some of the details you provide here. Make sure you let me know in the event that this ok with an individual. Thank you.

  3. CN Gadget

    very few sites that come about to become comprehensive beneath, from our point of view are undoubtedly effectively worth checking out

Comments are closed.