I have the following indentured list
1 part123
2 part127
3 part129
3 part134
3 part213
4 part2134
Need to convert to
1 part123 2 part127
2 part127 3 part129
2 part127 3 part134
2 part127 3 part213
3 part213 4 part2134
This will allow me to import to a drawing tree or org chart in Visio
If you can point me in the right direction I would be happy happy happy!
Hi Liberator,
Welcome to the forum
Whether this content is single cell value of 1 part123 double cells like 1 in A1 cell and part123 in B1 cell?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
That was fast.
Sorry I should have been more clear.
1 in A1 cell part123 in cell B1
A1 B1 C1 D1
1 Part123 2 Part127
Indenture number and part number in their own cell.
Not sure why 2 part127 is getting repeated???
1 part123 2 part127
2 part127 3 part129
2 part127 3 part134
2 part127 3 part213
3 part213 4 part2134
That's the catch
For Visio to import graphically " drawing tree" I have to flatten out the indentured list
All the "3" parts are children to the 2 part.
Please explain the logic how you are duplicating that text alone instead of any other tex?
The 2 part goes into the 1 part
All the 3 parts go into the 2 part
The 4 part goes into one of the 3 parts
Bike wheel Wheel hub
Wheel hub Bearings
Wheel hub Bearing race
Wheel hub Axel
Axel Sleeve
Still the logic is un discoverable without the clear sample data
starting with this
BOM Level Part Number Part Desc
0 921348700 M141 SIMUATED WEAPON ****
1 921348710 WEAPON KIT ASSY, M141 ***
2 921348720 TRIGGER HOUSING ASSEMBLY,
3 921348721 TRIGGER HOUSING, M141 ***
4 921348721-01 TRIGGER HOUSING, MODIFIED
5 921348711-05 TRIGGER HOUSING, M141 ***
4 91732A285 INSERT, HELICAL, #4-40 X
3 921348718 FLAG, SAFETY, M141 ******
4 SSH16G20 STEEL SHEET,16 GAUGE,A569
to this
Parent Part BOM Level Part Number Part Desc
921348700 0 921348700 M141 SIMUATED WEAPON ****
921348700 1 921348710 WEAPON KIT ASSY, M141 ***
921348710 2 921348720 TRIGGER HOUSING ASSEMBLY,
921348720 3 921348721 TRIGGER HOUSING, M141 ***
921348721 4 921348721-01 TRIGGER HOUSING, MODIFIED
921348721-01 5 921348711-05 TRIGGER HOUSING, M141 ***
921348721 4 91732A285 INSERT, HELICAL, #4-40 X
921348720 3 921348718 FLAG, SAFETY, M141 ******
921348718 4 SSH16G20 STEEL SHEET,16 GAUGE,A569
Disregard the descriptions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks