up vote 1 down vote favorite
2
share [g+] share [fb]

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
link|improve this question
1  
This seems like a good code golf example for scripting languages :) Can you maybe run Python, Ruby or Perl scripts? – slhck Jan 12 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 at 14:21
feedback

1 Answer

up vote 0 down vote accepted

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.