blackbeltrrf
Registered User.
- Local time
- Today, 10:09
- Joined
- May 10, 2007
- Messages
- 13
I have a table that is handed to me that is stuctured such that I need to move part of one record from it's row and move it to another record row in the same table. I have included a JPG to help explain this in case the format of the post gets messed up. Thank you in advance for any help.
This is the Current Table Layout
Lvl0...... Lvl0_PN......... Lvl1 .........Lvl1_PN.......... Lvl2......... Lvl2_PN......... Lvl3....... Lvl3_PN
0............ ABC............... 1................. DEF ..............2................. MNO............. 3
0 ............ABC ...............1 .................GHI.............. 2.................. PQR ..............3 .............STU
0 .......ABC ...............1.................. JKL.............. 2 ..................VWX............. 3 .......YZZ
0............ ABC ...............1.................. JKL ...............2 ..................VWX............... 3 ............ZAB
Needed Table Layout
Lvl0 ....Lvl0_PN ......Lvl1 .....Lvl1_PN....... Lvl2...... Lvl2_PN....... Lvl3...... Lvl3_PN .......Lvl3_PNb
0............. ABC ...........1 ............DEF .............2 .............MNO ..........3
0 .............ABC ...........1 ............GHI .............2 .............PQR ............3 .............STU
0 .......ABC............ 1 ............JKL ..............2 .............VWX ......3 .......YZZ .................ZAB
Report Needed Showing Level Structure ( I have this completed but the Level 1's are being separated when there are multiple level 2's below it)
Report Header : Lvl0_PN: ABC
Level...................... Lvl1_PN............... Lvl2_PN ..............Lvl3_PN
1................................. DEF
2 ..............................................................MNO
3
.
1................................. GHI
2 ..............................................................PQR
3 ............................................................................................STU
.
1 ................................JKL
2 ..............................................................VWX
3 ...........................................................................................YZZ
3 ...........................................................................................ZAB
This is the Current Table Layout
Lvl0...... Lvl0_PN......... Lvl1 .........Lvl1_PN.......... Lvl2......... Lvl2_PN......... Lvl3....... Lvl3_PN
0............ ABC............... 1................. DEF ..............2................. MNO............. 3
0 ............ABC ...............1 .................GHI.............. 2.................. PQR ..............3 .............STU
0 .......ABC ...............1.................. JKL.............. 2 ..................VWX............. 3 .......YZZ
0............ ABC ...............1.................. JKL ...............2 ..................VWX............... 3 ............ZAB
Needed Table Layout
Lvl0 ....Lvl0_PN ......Lvl1 .....Lvl1_PN....... Lvl2...... Lvl2_PN....... Lvl3...... Lvl3_PN .......Lvl3_PNb
0............. ABC ...........1 ............DEF .............2 .............MNO ..........3
0 .............ABC ...........1 ............GHI .............2 .............PQR ............3 .............STU
0 .......ABC............ 1 ............JKL ..............2 .............VWX ......3 .......YZZ .................ZAB
Report Needed Showing Level Structure ( I have this completed but the Level 1's are being separated when there are multiple level 2's below it)
Report Header : Lvl0_PN: ABC
Level...................... Lvl1_PN............... Lvl2_PN ..............Lvl3_PN
1................................. DEF
2 ..............................................................MNO
3
.
1................................. GHI
2 ..............................................................PQR
3 ............................................................................................STU
.
1 ................................JKL
2 ..............................................................VWX
3 ...........................................................................................YZZ
3 ...........................................................................................ZAB