Move text to start in specified columns based on value

January 26, 2012 at 07:26:55
Specs: Windows XP
I have an Excel report with Levels identified in numbers (0,1,2,etc.) Would like to move the data to a new sheet in a hierchial manner, based on the Level identified.
0 - move text here
1 - move text here
2 - move text here

The text I want to move resides in the six columns following the first, that provides the Level.


See More: Move text to start in specified columns based on value

Report •

#1
January 26, 2012 at 07:40:30
Can't you just sort on the Level Column and do a Copy/Paste?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 26, 2012 at 07:45:34
Yes, but the report is over 800 rows of data. The Level 1 data is a child of the Level 0 data. The Level 2 data is a child of the Level 1 data, and so on. So, the data needs to remain in the same row, just needs to shift to begin in a new column, so you can see the parent/child relationships.

The data refreshes weekly, so I'm looking to automate the formatting of the report.


Report •

#3
January 26, 2012 at 08:29:58
Well, there's no way we could have known that from your original post.

There was no mention or indication of a "shift to new column".

Please click on the following line and read the instructions on how to post example data in this forum, then post a bit more data so that we can see what you are starting with and what you want to end up with.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question