Spreadsheet: 775567d1649182434-stacked-data-clean-up-power-query-pq_sample_edited_040522
Sheet: Sheet1

original data set |  |  |  |  |  |  | ideal outcome
Column_1 | Column_2 | [NAME] | Number-Of_Lines | Column_5 | Column_6 |  | column_1 | column_2 | column_3 | column_4 | column_5 | column_6
G#CC#07231 | 1 | G#CC#07231 | 1 | Fake Name 1 | 1NEWMAN CENTER COUNCIL                                       _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC#07231 | 2 | G#CC#07231 | 2 | 15 TURNER AVE                                              _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 2602 TURNER AVE                                              _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC#07231 | 3 | G#CC#07231 | 3 | COLUMBIA MO 65201                                           _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 3COLUMBIA MO 65201                                           _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC01477 | 1 | G#CC01477 | 1 | Fake Name 2 | 1NOTRE DAME COUNCIL #1477                                    _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC01477 | 2 | G#CC01477 | 2 | PO BOX 73789768798798                                                  _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 2PO BOX 73                                                   _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC01477 | 3 | G#CC01477 | 3 | NOTRE DAME IN 46556                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 3NOTRE DAME IN 46556                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC13295 | 1 | G#CC13295 | 1 | Fake Name 3 | 1SEDES SAPIENTIAE COUNCIL #13295                             _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC13295 | 2 | G#CC13295 | 2 | 1 GUILFORD DRIVE                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 24141 GUILFORD DRIVE                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC13295 | 3 | G#CC13295 | 3 | STUDENT CENTER                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 3CATHOLIC STUDENT CENTER                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#CC13295 | 4 | G#CC13295 | 4 | COLLEGE PARK MD 20740                                       _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 4COLLEGE PARK MD 20740                                       _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#D500001 | 1 | G#D500001 | 1 | Fake Name 4 | 1ALIE P DUMONT
G#D500001 | 2 | G#D500001 | 2 | 48 TAMARAC | 248 TAMARAC
G#D500001 | 3 | G#D500001 | 3 | PO BOX 100000000 | 3PO BOX 716
G#D500001 | 4 | G#D500001 | 4 | FORT SMITH NT  X0E 0P0 | 4FORT SMITH NT  X0E 0P0 |  | 1 | 2 | 3 | 4 | 5 | 6
G#D500001 | 5 | G#D500001 | 5 | CANADA | 5CANADA |  | Fake Name 1 | 15 TURNER AVE                                              _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | COLUMBIA MO 65201                                           _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#S06BACO | 1 | G#S06BACO | 1 | Fake Name 5 | 1STEVEN J BACON                                              _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ |  | Fake Name 2 | PO BOX 73789768798798                                                  _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | NOTRE DAME IN 46556                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#S06BACO | 2 | G#S06BACO | 2 | 52 [NAME]_ | 21152 [NAME]_ |  | Fake Name 3 | 1 GUILFORD DRIVE                                         _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | STUDENT CENTER                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | COLLEGE PARK MD 20740                                       _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#S06BACO | 3 | G#S06BACO | 3 | STRATFORD CT 06614-4916                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 3STRATFORD CT 06614-4916                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ |  | Fake Name 4 | 48 TAMARAC | PO BOX 100000000 | FORT SMITH NT  X0E 0P0 | CANADA
G#S06BACO | 4 | G#S06BACO | 4 | 4                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 4                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ |  | Fake Name 5 | 52 [NAME]_ | STRATFORD CT 06614-4916                                     _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 4                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 5                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 6                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#S06BACO | 5 | G#S06BACO | 5 | 5                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 5                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_
G#S06BACO | 6 | G#S06BACO | 6 | 6                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_ | 6                                                            _x0000__x0000__x0000__x0000__x0000__x0000__x0000__x0000_