Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
share|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 '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 '12 at 14:21
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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