0

I've a list a values (column-1) which contains multiple parents and childs levels and I need to associate in another column which is the parent of each cell.

Any ideas on how to do that easily in excel? really thanks!

COLUMN-1            COLUMN-2
  **A   
  A.01**                **A**
  **A.01.01**           **A.01**
  A.01.01.01        **A.01.01**
  A.01.01.01.01     A.01.01.01
  A.01.01.01.02     A.01.01.01
  A.01.01.01.03     A.01.01.01
  A.01.01.01.04     A.01.01.01
  A.01.01.02        **A.01.01**
  A.01.01.02.01     A.01.01.02
  A.01.01.02.02     A.01.01.02
  A.01.01.02.03     A.01.01.02
  A.01.01.02.04     A.01.01.02
  A.01.01.03        **A.01.01**
  A.01.01.03.01     A.01.01.03
  A.01.01.03.02     A.01.01.03
  A.01.01.03.03     A.01.01.03
  A.01.01.03.04     A.01.01.03

FINAL GOAL

enter image description here

Solar Mike
  • 7,156
  • 4
  • 17
  • 32
Dario84
  • 1
  • 1
  • Include whatever it is you have tried. – JvdV Jun 15 '22 at 07:45
  • 1
    Looks like you could simply remove the characters after the last period, which will be simple. If you have an example which contradicts this hypothesis, suggest you give it. – Jos Woolley Jun 15 '22 at 07:48
  • Hi Jos! I've cases like 1C.00.200.0010.a, in which I should cut only the ".a" part. – Dario84 Jun 16 '22 at 09:11

1 Answers1

0

Jos Woolley's approach looks likely.
For how to do it, see How can I perform a reverse string search in Excel without using VBA? (adapating . for spaces)

zsalya
  • 454
  • 4
  • 8
  • Basically I should search for all the text part before the dot (searching from right) and than delete that part (that has no fixed number of characters) including the dot – Dario84 Jun 16 '22 at 09:13