Change data from columns to nested list

1

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

danihp

Posted 2012-01-12T11:14:53.627

Reputation: 177

1This seems like a good code golf example for scripting languages :) Can you maybe run Python, Ruby or Perl scripts? – slhck – 2012-01-12T13:52:40.150

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 – 2012-01-12T14:21:23.323

Answers

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.

F106dart

Posted 2012-01-12T11:14:53.627

Reputation: 1 713

Asked: 2012-01-12T11:14:53.627

Viewed: 288 times

Active: 2012-01-12T14:26:47.217