1

I need to move data from this format:

node 1   node 12 node 121
node 1   node 12 node 122
node 1   node 13

To this one:

node 1
   node 12
      node 121
      node 122
   node 13

Is there an easy way?

Note:

  • Data is in Excel
  • Target format may be Word
  • There are up to 7 levels of depth
  • They are hundreds of rows
2
  • 1
    This seems like a good code golf example for scripting languages :) Can you maybe run Python, Ruby or Perl scripts?
    – slhck
    Jan 12, 2012 at 13:52
  • Hi @slhck, yes, I'm developer, I can write code in 15'. But I would like to find steps that a user can reproduce it. Thanks about language improvement.
    – danihp
    Jan 12, 2012 at 14:21

1 Answer 1

0

In Excel, try moving your data from the 3 columns shown into just one column, stacking one on top of the other. Next, remove duplicates (on the Ribbon, choose "Data", "Remove duplicates"). Finally, sort in ascending order.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .