PDA

View Full Version : [SOLVED:] PowerQuery Steps to Move Data



enjam
05-07-2023, 06:13 PM
Hi all, I have a simple list with two columns, one being category and the other being the items that fall into that category.

http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAR0AAAEkCAYAAAASH UeAAAgAElEQVR4nO3d/28bZ34n8DeLAP0DUiiHaCFHK9LeUkLqw8oRQFYxCiOphjpAMhoJFxiSsVHBMYIFSNtyzxtYWPUk OEL8pRwgATS8dQ6REPggpZB9PnO0uycsHFUEVGlRbyCxG5Ne2wKku6jZH3bbQ7tt47kfZkjOjMj hF5FDinq/AiLmzDwzzzwz85nneWb00LWzs6MCwI9//GP86Z/ Kaj6WNZ0EFXqvP299D eabfa MisOypoOoUuet69atW rz58/x/PnziqyQiMiOK928unfvHhK3vq51foioTj39 h9w5/Ff7Xs9L1QgL4dK11 8uu91rH7wRQVyQlS8Spy3T/9iqQI5YdApy3/ s/9Udtr/8df/q4I5ISpevZy3DDrlUNVa54CodHVy3jLolKFOjh1RSerlvGXQKYNaL0ePqAT1ct7uDTrHTuIHM36 8lHPxX OnwzLuf1ntbNW3yh67JvTO/zneaAGALzHb9df4uWm6cRpR eok5uQIOl8 wPtdDwAAL39fxF8MvYivZn E9z/cdTpvdUtFtY7eMbz5/Sb8nGVNVVC987Y0JTav0ndfY42nHe s9uHVrRV8MPA1elb78NLsXXxxsk /ewNf/OVVfByzriP9/eDVnp5bbhkfXLuR fc3//7v Ld/ zf87l9/h3/93e9w7doHxa1069f4quVFvDTUje9 mKdmE/gzRH54LPM1czPQa6fIUe6/ JP3MPR69nsjHQcqTVXO2zL8XuFFjHbxdw9 DeBFvPpGkzYp8B28CuCrB3 PHX2pl4b68OqDHyHc9SP8dAt49Ycieo8B5ibDVYS7rmL28xfxxsyf4bsV26XqU1Xz59LoRXzzzT f4l3/ Z/zT//sn/OM//hb/ Nvf4oMPPtizbH6/xE9mf410bWePYyfxg 99jQ 6rmbK9aWhblO5vTT0x8CVqwgPr ArAK/ 8D28 exHCHfdxRcAXv1hupwb4zhQaapz3pauxKAD7Hz4N/gCwEsn/xAvA/junxwD8Gt88VNDk2BrBZ98uAtjkHqpDcCxP8SrLQA /2XmTv7zn30J4Bj KLDPPXGQ lzd8/kvly7hX/7ln/Hb3/wGv/3NbxH5q0jO5ez8n3TZWoIJAK3ZO/BAD y7 L9PAeAP8B OGZbZ iX 7ksAX/49vtgCgC/xkw93AWziF58blm Q40ClqdZ5W6oynl5t4hef9 HV17 D/3js74FXkD3Zbbz07SYAf6B1UL/eh8hqX mbrhP5Iv/Ef53EyMj3cOvWfy/z7rCJj//yO4j88Bje/P4vYX1v bvXsk2lfWlrjONApaneeVuash6Z//xnX2Lo9WN4Y/I0vmoBvprNNq3y epX2ZrQQe YtraNjf7bjz62nV9QbBk//d4xvDH0Hbz0OQC9z Xl74sYej3bL1OJAHTQjwOVpqrnbQlKbl4B0C6MLQAtL Ila9MKAFr8OPv9JgDt6Bl6EcCX EUMQOyX ZsPB4i6j/8K28X9Kyv4Csfw6p6g8mt89RgA2vFH wk4DXIcqDTVPW LV bLgVpfzRtDL ZuWm19ia9O/jkiQ9rXL/4y/TRmEx93Ae s9mFo9T0MZRIcrHdRqn5D PIBfvK531ST2fnwb/DFUB/emHkPbwD44vMvgdf/oMwNNMZxoNLU73s6Bjsfygh/mGfer74G8KLpqVXW11gc Gt8nDPlJj7u2iw5o/Wksm927uL wFXct0z9 aWrlovfrtyy71blW2dp66NGVL9vJBdJe2pl7qs5LOrk2BGVpF7O2/KCzrGTePN1INNXc8goP/nftc4CUcnq5bzlyIFEVJSKjRyoKEpmfOSnX//DvldIRI1rc3P//YCmms4fHzm97xUSUWN6792rFanplPeeDhFRmRh0iMhRDDpE5CgGHSJyFIPOIbEsNaFdqszvFhHt R96gsyw1ob3H/BlfK39Dy1IT2i/I2NK/by0EeBFYpMt8P VMVO9s30g Lq7i09OtFdlQd2gX/EsfO0tYUjoxIADz8SWMnzhV6wwRVUUZzasljPcEMLswqteARrGMJ5i9YLlDr42aajbZ6r22rCCv A8rbaO9pwpmFJxXYlQNuTcG8tw/vvNWH44qCZdPMJ5i9EMDs9hLGMzXPAGa3i52fi3YcsjXZUcs2iaqjzD6ddUzJwPTiLjYXr6O7pL StGLq5C0XsBITb2FzcrVht6iBbjs/gePebaGl Ez3eGUzvCcTrmBq5gbZbu9hc3IUiAlMjxkBRaL5le1IXpo5o5a8tn8A5w02CqFpsg85DuSvvnXB gotRgQ3lty5hWOtHzWiuAVpzs7sTD5Z/sCQADEzEMNWv/bjl9EQNI4Ol28fOt27v8VrYJ13L6IgYSd/HAtnZEtH O9elQflt/excPvX14Px0wXuvDcfkuHmyLmSCS2zoe7wDIu4zd/HVMjTRhyjStE5dLzDtRqfizwjX3BA W14HEOoSeMfOsv32CIdug34m2l 3WbTd/GNMlN42J9q9C7 m04pUj2lMXAMC2jDNjM4WTPUuxD2HtI0wlOnFZ74vJ9rF04qH8kalJOz W7RzeWriBeW8fTjYXPz8jb78RUfVV7OXA7tBtDOhPo9pHkjg3MWy7fMtrfTieGINwyJ9eLcdnAO HinmaU1iczgyXDE8GBiYt4PKL1sQmyF9M3RbSg PlZrRi6uYqe5S7zu1jsSCYHcGiLA EJZi904fHbuxg/Uc58ov3j0BZEdCAx6BCRo/j06kDQXqgsfz5R/TCNkfzeu1drnB0iqmeVGCP5BUEQAGgdyZXoJKLCNjc30d7eXutsEJWkv 18Rc5b9ukQkaMYdIjIUQw6ROQoBh0ichSDDhE5Km/QUUQXXC7zR1TK35AiuuDyS0jp31OSH679rLDRpCT4K1jeRPXKtqbjiyShqmrmIwvlb0iQVagrIb jLX0XjUkS4PGF0xFRDeceAgAjGHWo0ZTSvFIguPyRJ1O/IIhSkIPktd2ZFNNVsFNGl12y0ZT3hOBANwOVywS lcmznsFAgBqIIxqxBXYCsyhDSy wpc ypHWXLPwXJ74eUUiBm5vthLmbtOGRrVuYAl5L8hnnWtETlK7NPJ45wGIipKtTMhVEsN0IrKpIRH xCMQVVVrIQOcf1HuYMogugvWIjWMlcgngU 0WtGyYgP0clskAfiCHsm4U2m5wNhTzawKKIH4Y5YpmaVjGwgkL5JpCScDXfo21Khqis4zIeIKss 26MTDnrx3wmCs1GBDxTDXMOzKXIBsaK66ewfhiyeQNC2fDRbu0BUEsYFHKQApCZNRHyKXsmtzh6 4gGJ/D/UzUiuIO23ZUBSX06TDIOMEdWtHKOxYsuKwpQHnCiBdMEUcimf132GNsXgUQzWYCK8kINgIuNn p4vjIvNaEfgTLqVUoIjzGJlAyAl/BRD54Pel/Bw3NpxzNKHcIK3qHdkfYwydpVDEVCjpuHO0AoukrJyXBH4jaJwGAjUfgPVTApYgP0cA X0m4tremEw1kO4BT0iSivkH0ugG4ezHoi2KyqBqMB97C0YyoaBWr6QhyDEH9aZTLk8CVAs0DrQ8 iDA r71qTytCccblccAWi8EUu5W/SCjJiwSgC vKT3gisJR6MXUFCb0J5wh2IZfqA3AitJDE4Z yzM7xHpYiG6VqH835elyAyMo2RHAwW7keg/av 0BYpSH4PElf2924VkVF/23mOkUxEBw DDhE5imMkNyTtBUyiemQaI7m/7XyNs0NE9awSYyTzx/aIqCj8sT0iOpAYdIjIUQw6ROQoBh0ichSDzgGwLDWhXVqqdTaIKiJv0FmWmtDeY/6Mr5W/oWWpCe0XZGzp37cWAryQdHvLehTLtc4UUZXYvhx4XFzFp6dbK7Kh7tAu9v Ev3EZy3prIQChZxTTi9fRXeN8EVVaGc2rJYz3BDC7MGq4Kz/B7AVLTWht1FSzyTYRtGUFeR1Q3kZ7TxPOLDypwK40jpbTFzGAGSzlrFkWKusnmL0QwOz2EsZNNS ctnfY9gNltJ/aEaK8y 3TWMSUD04u72Cz5btyKoZu7UMROQLiNzcXditWmGsZ2Ckl0ou3lclewjqkRBacWd7G5uIrL3hmc 6 nC47d3sbm4C0UEpm5kbwhETrINOg/lrrz9DAMTrPpXy/JnY3jo7cPJ5vLXkT0 rTjZrQX48RPavJZveYFEEs8qkFeiUjnWp0P2HspdaJf1L94JKDdFtNQ0R0TVwb8yrxMM8HRYVOg 9nVa8cgSYj uPwLdlnBmbKZzsWYr9CiUrs6yJ6kTFXg7sDt3GgP40qn0kiXMTw7bLt7zWh OJMQh8elWyUsuaqJ5waAsiKgqHtiCiA4lBh4gcxaBDRI4yjZH83rtXa5wdIqpnlRgj QVB0H6N7d69exXpJKLCqv9je0SV1992viLnLZtXROQoBh0ichSDDhE5ikGHiBzFoENEjsobdBTR BZfL/BGV8jekiC64/BJS veU5IdrPytsNCkJfkt5 6VU4XREB4xtTccXSUJV1cxHFsrfkCCrUFdCcJe/isaliHB5wuiIZctaTUaAsIeBhxpOGc0rBaLLD0kS9TuyCAUpSH5LTUgRTTUbRXTpNRttWU84DkQ DvKMjBWkyCl8kaQ7q7hBWYkHEw9egFWuucseeGlL2GKSPiQIxM98PU1Er4p7abLb2qaXPztO3R7 RPZfbpxBEOAzFVharKKK0C5EZoRUUy4gOCMaiqipXQIa7/pO5jLu7DYG OMhD6EcQGHmUChbXcFYhngU/02lEy4kN0MhvoASAamIQ3qc2PBeMIX0uHDgViYAORZDYtgjGoeuRTRA/CHbFMzSsZ2UDAb143UTlsg0487Ml7pwvGSg02lF8HjuaNu3Ekktlv5nIXIBuarO7eQfjiCRgWRz C2gnRMF/qDwMYjLXCkHmHDsF330Q7DPAmTUR8il7JbcoeuIBifw31GHdqnEvp0GGSqx1ibsfLB68mfMiX5s zcGTxjxYjfpPooOw3aVO1Gg46ihzy2OsMfYvAogWuy6iWzwkXmtuY iw1KbyVDuIGpXC1JEeMIdenNL63z2Fbvd1CNsGAJLIBpEzNSpFMyuN/PJ1pqIylWhoOPG0Q4gekdvgKUk ANF3BfT1flDTcCliA/RgKWTVy9DX RS0TVM5VoJNZ1kAvFgLHdN1t2LQV8Uk4e6g5 qpWI1HUGOIag/jXJ5ErgSC9our/U/hOE59E vAHdoBWqsw9yc8cxhMFmgk12QEQtGEdDTTHojsC91S1oEzE uMh3FboRWkhic8 SZT1Q 0xjJwWDRpyztQz0MbZGS/PDMDSJp6IhWRBcmvcnD/TSR8upvO88xkql8yUTc0nGcwqONGmaIDg3 2N4hJchJRPweuFzZab4IazlUfQw6h5b2kmao1tmgQ8c0RnJ/2/kaZ4eI6lklxkjmj 0RUVH4Y3tEdCAx6BCRoxh0iMhRDDpE5CgGHSJyVN6gsyw1ob3H/BlfK39Dy1IT2i/I2NK/by0E0C4tlb/CBrK3rEexXOtMEVWJ7cuBx8VVfHq6tSIb6g7tYv9P BuXsay3FgIQekYxvXgd3TXOF1GlldG8WsJ4TwCzC6OGu/ITzF6w1ITWRk01m2WpSa/ZaMsK8jqgvI32niacWXhSgV1pHC2nL2IAM1jKlKdWZnlrQtsyzuSskeY6VkS1VeafQaxjSvZien FXvxM/wdOi07Zi6OYuTi4EIGxdxGboVHlZaGTbKSTRiZ6Xta/LUhemjtzG5k2trLYWAhAuyFBuimjBEsZvAO8v7qIlPe 2jHdOiGgBsPdYEdWWbU3nodyV9 46MMGqf7UsfzaGh94 nGwGsC1jWunE5beywbnl9EUMJO7iwTYAnML4zXSAAVpe68PxRBLPDOvjsaJ64lifDtl7KHehXda/eCf0WkzaOqZGmjBlStGJy/q/thYCWnM1Y7iqeSXaD/6VeZ2wD/DD TuV10YhyF5ML8a0 dsyzozkGnCZqD5U6D2dVrxyBJiP64/At2WcGZspnOxZKtPRTHk0v4ke7wymi xsX/5sDA rnCWi/ajYy4HdodsY0J9GtY8kcW7Cvoqv9T2MQeDTqwJaMXRzFT3LXeZ3edJPBk9cx7Qwg3P69OmWCQzU OstENji0BREVhUNbENGBxKBDRI5i0CEiR5nGSH7v3as1zg4R1bNKjJH8giBoPyZ77969inQSUWH 18GN7RKXqbztfkfOWzSsichSDDhE5ikGHiBzFoENEjmqQoJOC5HdBVPIvoYguuOwWICJH5Aw6Kc kPl0vE3ku08MVdKSnJf7iCREqC3 WCK/3xS0g5uvlDVt5UMzmDjjt0BUFEccd6DirXEI4H0S84kLPDRBHh8sxhMKlCVbVPcnAOZyUnww6RM/I0rwT0B4GoJeood6JAsB/ZmKPVfDJ3Z2vtSBEN8/RP5m6aL6023ROOA9EAXC4X/OmLz1Ib2HtjViBm5vthf80WyLtjFIiBKIKxFYTc2anu0ApW0hPy7rcC0eWHJImGfcg1DSirvImq YWdnR93Z2VFlWVZNYkEVCKqx7AQ1CKjBmHERqDBMSEZ8KnwRNZlZ3qdGkoZ5hmXt0 5dXlVjatA6P/M9qUZ8UGHdniH/1u0V2n41bWxsZL8kI6rPVM5WdvutHZNcx8k8TS8f6/4altlb3kRmfd8OV2Q9 TuShX5zE0u5g6gvgkvpak5KwmTUh8ilbL3HHbqCYHwO91MAUo wgQ4c1W/W7qMdwMYjrZ iUNrcGYK8EkK6MuDuHYQvnoBxjDxjbUFrIm7gUa71lbX9KkkmELddoJj9lmFt8Zqmpe5jLh5ETL bsb77yIaoim6dXAi5FfJkmlnInCt9gL9ymZeIIe4xV9gCi6Vnuo gwnNTKnSjQcdSQ3iZtHloHt768J1zgYtW2kcg7cmfp26 V0vfbImdg88DrsysfouqwfWTu7h2ELzoJKaXgTtSHwV63ZYkgYmq281P76LWN1CNsGC7sQNR8p7 VNm4siwhPuyKZJRuAruHs eD355pW4/Wqx1iitytpvC483R5okEnG78iGqDvv3dNy9GPTFMXd2ElHfIEwxx92LQV8Uk/k6HZMJxIMxwwVtqO4XSpuWbo7loFzbe8ePBrKdxykpR55L3b4j9BplwNzxnZL8OTt0c 13Qfr Bgw97znLx6a8iSomb0eyTutwNHcgG bqHbiGj6HTMxbMP69QWq2DVZvu03uHjevzRSJqMNMRmlQjPp8aiWXTwNI5a 04Lrj9KjJ1JKdzo5dzoXI07/fezv3c07LT8 5rjvImMqpUR7JpjORgMFixYJaS/PDMDSJp6ARVRBcmvcnso BDikNb0EHU33a vsdITibilo7jFB5tVGtrRHRQVO3H9gQ5iYjfA5crO80XYS2H6LCr4i98uhFaURGq3gaI6AAyjZH c33a xtkhonpWiTGS WN7RFQU/tgeER1IDDpE5CgGHSJyFIMOETmqQYLOE8xeaML4Wv4llqUmtEtLzmWJiHLKGXS2FgJo7xnF8p45 hS/uStlaCBySIKGVaXuP8ZOr7IkaQ86g03L6IgYwgyVrcFn7CFOJYZw64UDODpnj4io2F3exubiKy9 4ZnDsUAZcOozzNq1M4JQDzcfOJvxyfAQQB3Zkp1ru05Q69Nmq5gxubOPnSatMFeR1Q3kZ7TxPOL DzRkmzLOGNY194a1xLGM/MDmN222/UCea ZVpzs7gSepbCVmVYgr3nLJV0zzV8uWq222DIj2r 8fTrdvmFAUQwn9xKWFGDAdyozZVnqwtSR2/odeheKmMC5C7J sSxhfCyBy7fS8zoB4TY2Q6cKpG3F0E3D8ou7 PR0q7a G8D7i9n1zd WDRcmMD92A22Z7QFTI/kDiX3ea kJHiyv43j3m2jRpxQs5xLKZVpYx9RneuDflvED2YtpPe3mYgxDzY7uLB1C TuSTwjmJtaagnnvBN5JN622ZUwrnbj8VjYItZy iIHEXTzYBrCdQhJevKKfxC3f8mbv3oXS5nQK4zfFzIXY8lofjieSeGZYYmAie9FoTcQEnuZaX1n br66Hcpde2 jCVKITPa 1FpnX0sql2zdsqUXlaEYTVZHNH3yewjtiJ4T4EsZPnMJyfAbHu1czJ7dmHVMjTZgyTevEZQBods ODu3i6DXQ3602zI7cN6W3S5rG1ENCaXRnD9nuHdTzeAZDz7l369qvpuLiq1 igNUtHAsCtGIYAFMpr6eWiaxbx6S3gzEgT2q15IKoS278yb3mtD8flG5h9C3isdKLnlvWEHMb04 nVDH4/BdgpJrGM c7EMY3rxVHFpc1kbhSB7Mb0Y09JsyzgzUmhU8U60vZxvXonbd5Jey3y8A BlwDavZZWLQbOITxdFaP1hXRj/1i7G aCAqsj PZ3mN9HjXcfijRuY9/bhZLN13gym0528VjtJPBSy/RCbxoumUNo0UzPAbPmzMTy0TJsfy3aEbi3kyHOp26 VNQXz6YBZYl5zlUtxvo02b1kJiUpSYDwd7UnKlLyOgYmYpWnViqGbq8CFLrTLhsneCSg3RbScuI 7peBPae3LMK5QW6VrWGISeMb3afx3TQhPO9cwAAI6LExgw/fpTJy5P9GHRVLMSLXkuMu/2hVIVD2VzXgYmdvV mCLK2bZcbKyNon1sJvtduI1N1nKoyqo2tMXWQgDCcp/pIl6WmjDdwn4DooOo7oe2eLa1DhxxG2oNT/D0mU0CIjoUqjZcaXdoFZcvdJmaV3w6QkRVHCNZe8lvqHobIKIDyDRG8nvvXq1xdoionlVijOQXB EH7sd979 5VpJOICuOP7dFB1N92viLnbYOMp0NEBwWDDhE5ikGHiBzFoENEjmqQoJOC5HdBVPIvoYguuOwWo AIKlzFRMXIGnZTkh8slYu/55dyJl5L8hytIpCT4XS640h /hFSt80RUBTmDjjt0BUFEccd6zSvXEI4H0S84kLPDRBHh8sxhMKlCVbVPcnAOZyWGHWo8eZpXAvq DQNQSdZQ7USDYj2zM0Wo mbuztXakiIZ5 idTe8mXVpvuCceBaAAulwv 9MVnqQ3srQgpEDPz/bC/Zgvk3TEKxEAUwdgKQu7sVHdoBSshN3LWLhXRXBPKWS6F0qUg f2QUsYyE6GYyiVXGdqVsV2ZKhBdfkiSWOPyplrL26cjaFHHdNJoMScbchTRg3BHLHt3jmwgkDmp FYiBDUSS6Xk IBiDKgsF0roRWjEsr6r6xadAPAt8ombXF500N0GigUl4M9sDwp78J7Z93h2UeoQN7Kf2qED0hIF IUt XGDBZ7H7EEfbcQb qQlWTiPiiCLg8SFwxlOHZ4su4cJnGEQ4DMVWFqspghflwyt RLPSbm1jKHUR9EVxKnykpCZNRHyKXsqeOO3QFwfgc7qegX0wdOKrfvd1HO4CNR9oJWCht7gxBXg khXRlw9w7CF0 YRo4x1ha0JuIGHuVaX1nbr5JkAvH9pFfuIIogrmSqSeZyKiQYS1/8bvQOaoFevy9ox6zYMi6yTLPbo8PK5umVgEsRX6aJpdyJwjfYazmZ4wh7jNXpAKLpWe6j6DBc9M qdKNBx1JDeJm0eWge3vrwnXMTFGkci73hWpW /bvm88NRs48YybqAypaqxfWTu7h2ELzoJKaXgTtSHwV7r/TOoV5WNH/1OmHqEDcNJGIgGEZOF4tLmoojwhDuyaZIR Arung/evFdjiduvFmuNshyW2oizjGVcJ2VKdc3 PR13LwZ9ccydnUTUNwhTzHH3YtAXxWS 3tpkAvFgzHDyGarVhdKmpZtjOSjX9tZ0ooFsx2ZKypHnUrfvCL1GGTB3yqYkv96B7sbRDkOnfkq CP2CoP hBK7svCkS9b8w2XZnylnFdlSnVtZ2dHXVnZ0eVZVnNJRnxqQDUYCznXDXigwoYPr6ImtTnxoL55 xVKqyYjqk f7osk96zPF4moQQTVWGZdPjUSy6ZBZp4hL6adKLD9KtrY2NgzLV3OufMSU4PG/YoF85YV4FMjyWLSaftvLJJkxGcuo1jQUI6Fy9i TLW85D6P6CDo 3a4IusxjZEcDAYrFsxSkh euUEkDZ2aiujCpDepP406vDi0BR1E/W3n63uM5GQibuk4TuHRRrW2RkQHRdWGKxXkJCJ D1yu7DRfhLUcosOuimMkay/5haq3ASI6gExjJPe3na9xdoionlVijOSq/dgeETWWuv xPSKiXBh0iMhRDDpE5CgGHSJyVIMEnSeYvdCE8bX8SyxLTWiXlpzLkiMK7XfhciFyWs6gs7UQQH vPKJb3zHHuJN5aCDRgkLCxLeNMTxPa058LMrZqnSeiKsgZdFpOX8QAZrBkDS5rH2EqMYxTJxzI2 WGyNor2kbvoubWLzUXto3TfxQ8WntQ6Z0QVl6d5dQqnBGA bq5pLMdnAEFAd2aKVvPJ3J2ttaO1UcM8/ZOpveRLq00X5HVAeRvtPU04k774LLWBvTWuJYxn5gcwu2236wXy7pgljI/NYGAihqHm7NSW0zF8erpV 7Lv/baZb7fuso4fkb28fTrdvmFAUQwn0hKWFGDAdyozZVnqwtSR29m7s5jAuUyzYAnjYwlcvpWe1wkI t7EZOlUgbSuGbhqWX9zVL74ljN8A3l/Mrm/ trkJMj92A22Z7QFTI/kvBPu8O2g7hSTsao/73 /88 3WXe7xI7KXvyP5hGBuYq0pmPdO4J30xbEtY1rpxOW3skGo5fRFDCTu4sE29IvJi1f0u3fLt7zAs 5R2UhZKm9MpjN8U0ZJe/rU HE8k8cywhLG2oDURE3iaa31lbb9KdpJ4aLvA/vc7/3ybdVf8 BFpbP7g8xTeETshxJcwfuIUluMzON69mjlBNeuYGmnClGlaJy4DQLMbHtzF022gu1lvmh25bUhv kzaPrYWA1uzKGLbfO6zj8Q6A5tzzSt1 rabnqjQAAAvESURBVFR2v83z8667CsePCCjwV Ytr/XhuHwDs28Bj5VO9NxqtSwxjOnF64Y HoPtFJJYx3zmxBzG9OKp4tLmsjYKQfZiejGmpdmWcWak0MjAnWh7Od 8ErdfLScEDOBtLK1dR3euJlbF99sw327dlT5 RDr793Sa30SPdx2LN25g3tuHk83WeTOYzveEZSeJh0K2zb9pPEELpU1LV dzWP5sbE zZH4s20m6tZAjz6Vu3xFajdKYd0CrgZzJkb9y9rvYcjGtuxLHjyiHAuPptOJkdyem5HUMTMQsTa tWDN1cBS50oV02TPZOQLkpouXEdUzHm9Dek2NeobRI17LGIPSM4bi4ik9PX8e00IRzPTMAgOPiB AZMv4HQicsTfVg03ZlFS56LzLt9oVRcy kYFAQgGJsr3gkoN1sB7He/beafsFn3Po8fUT5VG9piayEAYbnPdBIuS02YblnNPgqmusXjR1Z1P7TFs6114IjbcNd7gqfPbBJ QXeHxo2qp2nCl3aFVXL7QZaqea80k3iUPAh4/qpYqjpGsveQ3VL0NUFXx FF1mMZIfu/dqzXODhHVs0qMkfyCIGg/9nvv3r2KdBJRYfyxPTqI tvOV S8bZDxdIjooGDQISJHMegQkaMYdIjIUQw6ROSovEFHEV1wucwfUXEya4fH3rIWoVjn yWkapZDosqxren4Ikmoqpr5yIJT2Tp8jGWdjGwgYAg8gqxCXQnBXdMcElVGGc0rBaLLD0kSLXfl FCR/nrt1SoLfdCf3Q8rctm3S6fNERYGYM21jcoeuIIgo7ugFoYguuEzVTLsyA1KSP09ZE9VemX06cYT DQExVoaoyBKQg T0Id8Ry363dIaxkpvsA3yB69du2IuZIZ2lKRAOT8Ca1 bFgHOFrDd7OSz3CBnzwenLPti2zlISz4Q792KhQ1RWEWEWiOmIbdOJhT967aTAmI9PaSt3HXDyI mKH9pd2tN/DIdJdVcC0MRD7RmwopCZNRHyKXLOnic7hvSBeMZS8coT8IbDxq6P4N5VoYcUNgNimqzLK1JKJ6U 0KfjiHIWCUTiO Z6IHXF0fCMN6UIgYQDV6x3HnjCHuMTYUAoiXvxsFnDPCBjQiStn04NmXmDmElGcFGQJvnZ9uK6k xlHpl7vPDtmZhEIm5oIigiAlFzbUgTNDQFDm TwBTgC3YaFyizTHM2ho6wh08dqa5UJui4ezHoiyJgOLtT0iSimSaCAjEQNTfJDOkmeTcuXkll5o F3792AqKYq9HKgG6GVGILRQKbK75kbzDYRlDuIAogGrO/8uBFaSWJwzth3xHdS7BUoM0U0TNc6nPmqA9UT0xjJwWCw1vk5FDi0BR1E/W3n63uMZCKiXBh0iMhRDDpE5CjTGMn9bedrnB0iqmeVGCO5aj 2R0SNpe5/bI IKBcGHSJyFIMOETmKQYeIHMWgQ0SOyvtb5stSE85Z/jp5YGIX4yeqnaVDaG0U7WMzma8sZ2pkeYMOABwXV/Hp6Van8nI4bcs4MzZjCDRLGL8gY uEiJZa542oCspoXi1hvCeA2YVRtPc0ob1nFMsAgCeYvdCkTzNOh3Zh9RjnBTC7nZ5pk06fN762h PGcaRtFJ9peTv/7FMZvGgKOpezG19Iz0mVjWM3aKNovyNjSv24tBHKXed516uswHasmtEtLpm3mPlY22yMyKLNPZx 1TMjC9uIvNxevoxhPMXujC1JHb2FzcxebiLhQxgXPpk7JZxKeZ6Z2Atw8nm7U1LUs50hkuHACYH 7uBtlva/GlhHVOfLeXI0wHV/CZ6vOuYGsl1kS5h/AbwvqHs5m byyavbRk/kL36MdrF5mIMQ82F1rmE8bEELt8yHCvhNjZDpwAUOFZ5t0dkZht0Hspdee9qAxPX0Z3 sv0TLCaGMa2fnADQcvoiBpDAU9OFtISPZeDyRf1Ovi1jWunE5bcs6RJ38cCQbmAiewJ3 4aBZ6niLrwDoRVDN/VgOmKtIZhrPS2v9eF4IolnRa97Bktr1mk269xOIQkvXtHLuuVb3mxZF3Wscm2PyKwyfTo7STzcM/HbaPOu4/EOgEyt5m3MC7exaboDahfblCltJy4X3mpD6Q7tYjOkNVGEkQBwSwu0WwsBCPK6Ycnh4lbYLOLTW 8CZkSa0w3ws866z2Q0P7uLpNtDdDCzHZ4Ajtw19SzbHymZ7REa2QadoL3twHEnLxF/hccLQV7E2inPKMKYXT1mWG8b0oqHWdMi1nP4Il5e7tGC9MwpB9mJ6MaaVz7aMMyPWcrbRLOLTRR FaP1wXxr 1i3HYrHM7hSTWMZ8JLNbjVeBY5doen8KRRWXe02l Ez3eGZyTsn0tWws3MJ/pu1nC NiMuUlmSDe98KQi2TiIthYCOGPc/7WPMGUM1gbLn40ZapSteOUIMB/Xy1x/Cpbbt9HmzT3HtM6dJB4K2T6bTWOAKelY5d8eUWVqOmjF0M3beNzzNtrT7/Z4J6Ck w7WFMwDwFiT9n k30VpxdDNVeBCF9plw qMaRtcy mP0GPa/05c1ptWaL6OaaEJ53q0YHJcnMCAoUbZHbqNgUyZD2N6YhjnbuszLe/ QLiNzRMAYLPOE9cxHW9Ce48hg5ljUeBY5d0ekRmHtqCMrYUAhOU U8Bflpow3cL GeLQFlQFz7bWgSNuQw3zCZ4W/6iMqCgVal5RI gOreLyhS5T84pPoajSGHTIQHtnaKjW2aCGZhoj b13r9Y4O0RUzyoxRvILgqD9/OO9e/cq0klEhfHH9ugg6m87X5Hzlh3JROQoBh0ichSDDhE5ikGHiBzFoHOgpSD5XRCVwksS1Yu8QUcRX XC5zB e3FWUkuA3lrdfQqrWeSKqAtuaji ShKqqmY8sOJWtQ0YR4fLMYTCZLevk4BzOSgw71HjKaF4pEF1 SJKo35VFaBUgraqfrRmlp2PvXdzlR/Z6skmXaT4oEHOmbQQKxEAUwdgKQu7sVHdoBSvpCZbyy1vjVMQSyhZISf48x4Soesrs04kjHAZiq gpVlSEgBcnvQbgjlr1TRzYQSJ/k7hBWMtN9gG8Qvfr1pIg50lmaFtHAJLx6LSAWjCN8rYHaealH2EAQ/XlrkQrEs8AnhvKLTuZoeikiXIENRJLZ4GVbtikJZ8Md jFUoarmoEdULbZBJx725L1LBmMyMtdJ6j7m4kHEDO0vd gKgtjAI9PVoeBaGIh8EoIbAFISJqM RC5Z0sXncN QzlgLEPqDwMajxunvSCYQt11AgLyilxcAd 8gfPGEeZzGRxL8loBTXNlGcaeB4jcdDCX06RiCjFXOC8cDry OhOHqUMQAosErljtqHGGPsQkQQLTk3WhspmaQJ7ynrKPhvdM0NmXrDmElGcFGQJvnZ9uKHFKZR YeL3x7JiaRiPvg9ehfFRGBqLk2pAkaqviHsKov9CNoV NQRHiMzaBkZE9ZB2MqkhEgfNba7CpQtplmbwwdYQ fTpIjKhN03L0Y9EURMJy1KWkS0UzfTbqz1FJb0tNNHuq7rIBLER iAXNHbkry56x9KNdy12rcoU8QQRie9DEoqWw98O69axBVRYVeDnQjtBJDMBrIVOU9c4NIpvsilD uIAogGrE9g3AitJDE4Z w7OnzvqLhDK1pNxdAU8swN4pOQGxBkxIJRBPTpk94IgrnXkjkGWrAqULaKaJiudTjzlQhygmmM5 GAw9 lMlcWhLeggEYb/JwDg91d xjGSiejg4XClRJRTuoZTaazpEJGjTGMk97edr3F2iKhe/H6OaZUYI5kdyTXAjmQ6iCp13rJ5RUSOYtAhIkcx6BCRoxh0iMhRDDpE5CgGHSJyFIMOETmKQYeI HMWgQ0SOYtAhIkcx6BCRoxh0iMhRDDpE5CgGHSJyFIMOETmKQYeIHMWgQ0SOYtAhIke5bt26pT5//hzPnz H3vdX6IqMG9IAjazzreu3eP4/Y6hGMk00HEMZKJ6EBi0CEiRzHoEJGjGHSIyFEMOkTkKAYdInIUgw4ROYpBh4gc9f8B89BZeNUH2 PkAAAAASUVORK5CYII=
30802
I would like to create a separate list in an Excel workbook that updates dynamically. In this separate list, each category has its separate column, and each item that belongs to that column will populate as rows in that column. It is possible for the user to introduce new categories in the future to the list with two columns, so the number of columns in this separate list must be dynamic.

So far, PowerQuery has gotten me here:

30803

However, I need to ensure that the null values are removed so that I have a list that looks like this:

http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAesAAACNCAYAAACXKVJSAAAgAElEQVR4nO3deVxU 1f/48dedhS3LFnfZTFT8uK9gLpQ1uZsFLmlJX7c WUJuZaX2zTRLVNJKvwV 9OOWCpmA 2QuSEmKoLikkCImarb5S9lm5t7fHwMILggugPJ Ph4 Ys7ce 57Zm7znnPuOfcojRo21CgjmqqiaRooiv2xpqHk/V2uKkAIlZUOBY0rH0GZnYzitl3vMyv8v5J2TZmChoZy1XPymd bivv8i5RphR9rKHnnwdXblfa4FModFSKP3GWGMj9iRXxTC2cLUbYUpchbLx/DvedGn9n1ygs 7UI/1OUzv7dd/3Mu kC5OivLL7RSUzIyMuRtE0IIISowXXkHIIQQQojiSbIWQgghKjhJ1kIIIUQFZ4iLiyvvGIQQQohK zdHRkbZt297weUPHjh0LHsTFxeFtalcWcQlRhGpTSd2RSIcOHco7FFEJWSwWEhMTadfXmHIiqhn JwckpOTi91GusGFEEKICu6W5lnv2/FDwd/1mzTikeqP3bGAxL1FU1WObUu45f11eh0Nu7Yp8fY2m40ff/zRvq9OR6NGjXjsMTn/Kiur1Up8fPwt7280GkvVmrZYLAXH0 v1NGrUiEcfffSWjy/ubbm5uezdu/eW979Z13dhpU7WmqYRtWRNQYLeGrGegaMDqd kUWmrEvcJvV7P888/X r9bDYbUdFRpd7n66 /LkjQ0dHRDBs2jIYNG5b6 OL 4ODgQNfUu9X05ODps3by71PqtWreLRRx9F0zQ2bNhAYGAgDRo0KPXxxf3B2dmZXr16lXq/zMxMtm3bVuLtb7kbvEuvpxk3awpOLs4c2nvgVqsRotT0ej09evRg8uTJODk5kZSUVN4hiUrEaDT Sq1cvJk2ahNFo5ODBg UdkqgEbjlZ/3nhT2I3fkd2ZhbtniyrQUEa2vEYZvcfxcrdZXRIUeFomsb58 fZtm0bOTk5MihNlClVVTl37hzbt2/HarXi4 NT3iGJSuCW7w1 6KdEAJxcnMm6nFnCvTS0lPXMeSeKM3klitKBlyKG0/pWAxGVjqqq7N /H7B3QWVlZZVgLw1r7jGips1ik4M/k6f2whNQrbkcj/qQkC2evPrVcMpsLLAtl6zdYYxedpDOo75kWMGBbeRm7SZs9DIOdh7Fl8NkdHJFY7PZSEiwj9Nwc nIq4fkH2HK5fGQdM0LW8ysARpwf6sLIzwMp2VVLUZndtGWdkXaaqCVr OXwsSLlXXo9zbiQKdTxdGNrxPrSHVVRaBccTmhkOHNLlagVlIZ9mBDxFYM7gaaeZMuEkYz/7KfSHV/cEzRNIy0tjVWrVnH8 PGC8vxu8KlTp1K7dm1iYmJKUJuCTvc4TVrVQU1P4HAagIqqnuBwUgZ6n2Z3JlGrVnKOfsOU4aNY JKflPU1VVX755RfWrFlDSkpKQXl N/i7775L9erV2bRpU6nqNTg/yNNBS1m6dBFfSqIWJXTTlvWhvQc4vDeJjLTTvFZoEFnW5Uz uvAH2Zkl/FVZDE07iXniDA66 8KueDK6DCe49hbmRbjy8pphtFTjWTlwEecGvcu4ZoeY8140ysB3efLMDDanAWlhjItN5uU1w2l1 29GI22WxWJgyZco15UajkQ8//LDE9eS3oBMSEjhz5gzjx48H7En88uXL/P777yVv1WAfPf54k1bU2bCJhMNp9HJ3RT1xmKQMPT592oPNQnbcV4wKjwf0GJ068epXw2ljySbu q1GE5w861htx6vQqC4c2v1KuN LUaQRfDLEQPjOKU8CphcOJT7aXfTUqnHgAvQPOnUfxZWBL 2ux5pC67l2Gfp6B0bE L7z3Lqaahd8EKznH1vHBzGh RYfRsT7 702hp2eJX3alk5mZybRp064pd3FxYerUqSWux2q1sn//fvbt28fZs2cJDg4Grpx/f/zxB1lZWbe5PKONnMtHiPnkU5Kqt8SWdIh/uowkdEBDYsPfYMleKGiBhw6gYWw4b9gL0Ts QCP/SUx86jEOR81g9vozoHfkgUb TBrvx8Ox/2XC1zZMpl9Zv/4cjg80wn/SJLp73Ea44qYuXrzIzJkzrymvWrUq77zzzi3XW2zLOutSJvt2/ECTdi3JSDtNRtrpgue2Rqxn7sQPybqcyaDXX7nlAPJpQEZsBi0 DmPumBJcA1IUWo95j 6eCjq/kcyVRF1hXC8plzZRA1y6dIk9e/bQokUL0tPTOX3afv7ZbDbWrl3Lhx9 SG5uLq 8UsLzT6dD93gTWtVRSU84zAlV5cThJDL0PjRrayU3ZT0fLf2DgdOW8J/wt lZ8wfCv4rD8uMS/nvAjzcWL KrEU9gND7BsMAWHI ZydI/BzJtyX8Ie6snNX9YzNKkJxjxznN4GJ3we20RX/2PD/pz7vRaupSledvV nELG9LsIamKgT 8 vKfsLfpUTONdcs2kFYQsI3cnDgWzzHj9cZSFocvZGirNL5dvrHQNuJq10vKpU3Umqbx//7f/yMhIYEmTZqQnp7Or7/aO69zc3OJjIxk5syZaJrGSy 9dNsxqxaV80cu4Tf1S YNaszPMbP4 khjBn 4mLCFb/L0oz wZOVhHuo6hqWLvuTzV3wxGNxp6VWDS3HL SLWm6Cli/jy0xdp ksUX28 BViwcogTD40kbMFYTDVOsmHHvtuOVRTvekn5dhM13KRlfeKoveuxS6 n eXwMQ7tPUAdTzfGhVxpNeVP4cq6nMmJI8fJupzJI9UfK34ql6axd94I9s5TUOo9x5uzmgAKeLah kRey1ul9ID85T5ky5ZYStaqqHDt2DL1ezzPPPENqaipJSUn07t27oNWkKErBFK5Lly5x/PhxsrKyqF69 g2mcukKusI3bNpH8i/1sSZloPfpQ3tNI/u3DNJyU0mb gqrwd5adrt fJqmceHsSXJTTjL1ldXYN3fimgavDtTaWSS8O5Sp9u969A7OePyW97dej09TXxQli q1VbSD5/mNqnlvgoaWdoH03Cx /XwoOwB0Rhy9SvVWVkr5yXnatGmlTtRg/0GYkpKC0Wika9eunDp1ioMHD9K9e/eC80 n0xVM4frnn384fvw4OTk5VK9evdipXNasf9g2fyjbdI480KgfY4PcQW/A4N6Kxh6gZtm48Pt5DO7 NPbQo8vyoFotFVvG75zCQo2sH1n dTKP 0/C5Gbj8P5TZF08w/yh9mlAescHyP/21ekM1K7mARwGm4r17O cAqRxfXflJ eZM2fekUQNN0nWe3f8SB1P 7dV/SaNOLQ3kWf7977mJii/HD7G6gX/BewDzrKzsnn38xk3rlhRaBcUxuDO9oeadpKjt/EiRMVkNBr5 OOPb2lfVVXZs2cPbm5uKIqCl5cXBw4coE fPlSrVq3IdkeOHGHJkiWA/UvaarXy0UcfXbfe/K7wuhs3cvb8b5DfBY4F0GFw8MJ/8lR65Wdd1Uru8XPUyo7i8//Zid7oRKdXv6I92cTpDDg08GfylF5XkrRqJafQ8A7VaiFl/Uo2/u7HG0sCaXFsHTPmmEv1XhgcnHmyyCA0URIuLi63fP5ZLBb27t2Lq6srBoOBevXqcfDgQXr27Fnk/LPZbCQnJ7N8 XIURcHJyQmdTscHH3xww7oNzg/y9MgvCGwL d3gJZ18aMvJJXXzDg44 jKyuwfkXAIccK76NCM/K3T925LFxdhbeuniDqlateotn3/Xc8NknXU5k4y002RdzmTuxCutosN7k2jSrmXB4794PVC/5Lk3YtebZ/b5wfcOGvC3/cXlQKuNesC5zh91TQMpLZB7jeXq3iHnL58mXS09PJzMzk0KFDABgMBpKSkmjZMu96b94UrqVLl9 KuXTv69OmDs7Mzf/75540rzusKb1kriqjwxfbr0u0BVUFXowZ11AT79WxPe/pVVZUTRw9w3msg06ZeScqqVaF6jTqoCfs5nNYLzxJcQ1ZVGycO7 c0FNRjs9mIP7SHoS2qcuGsDsW1JjUKYlVQPKtT02Yj/tBPDJP7VpeJ/GvSp06dIisriwMH7PeRcHJy4uDBgzRv3hywnxtnzpxh1apVdOjQgZ49e Lo6Mjff/99W8fX6fRUr1YTa3IiR089TY1H9nE4QYe S1Vq58Sz2HwBT//h9sSs0 NRrRrW3H0c3hdICW GJe5BN0zW bcUfe1/x P8gAsAi2ctIPmnosn60N5EUChI1MAduP2oAp2fplv0DDZOGsUmz/a09YRzV2 leOLt48rm1TLA7H5is9n44YcfMBgMTJo0qaC1vHDhwiLJWlVVkpKSMBgM9OnTBxcX /lX/O1H87rCW7sRlXHuyihwnQGDVx9e6rWfj1ZPZehqUAwO1H9 EpMat6Dmt6uZOnQ19tZ3ffwnv0e33kPolTCT1VOHsrpw eP/omXNKKIWDie 0wi GGKidVQ4C4btBOzd4HZ6jLrWmB6KZtjI/AFmvfBkd8HzDg4dGPbKIV5d9DlDd3BlgJo0sa/FuYuri48OabbxZMD1y0aFGRZG21Wjl48CCOjo707NkTZ2f753q7tx/VOzrRsNdATIkhrJwynJV6Rx5o6M kwS2xxIazJ cyrJzC0AhnqnYZydwBQxlyeAxL5g9lG2B0rkqXV2bR73bfCFGh3DBZ51 fzu8GB2javhX7dv5A1uXMgsT854U/cXJxLnhcPAWlQR8mRPQpWqrUo9vsMLpdUxZeqGxk3n/rFdnfo//7hPYvwaHFPUNVVQ4cOIC7uzvu7u6APYE3b96chIQEMjMzcXFxQdM0/vjjD1xcXAoSdUnoDA54 89gqf/Ny22WbOLCP8prWXenbnYc4aOXsv9wOr08G P/0VKuqga4tvz1pV14/Zrt/s0iP/tfAQGFy/14fbFfwSNnv9dZ6nft3uLusFqtHDp0CHd3d9zc7N9/ubm5NGnShOTkZLKysnB2dkbTNP766y9cXFwKEnWx9A480GwA074cULgQxweaMWB6GAOuLpu5lAF X19F1DEu7Xlt11zFLubZ4DIsKCptfdQxxr7lhsn5l4mvXlD3bvzftnuxQJDE/Wv1RDmdmFUngQtwOo9FIUFBQkTK9Xs8LL7zAk08 WZCY8weYHTlypCCB32l6vQHfp3qx5aP8lnXelK5eMnfqfuXk5MSYMWOKTMlycHDA39 fp59 uiAxK4rCI488QmpqakECF JuueHULecHXK6bfK/u4m7arhVoELVkDRlpp/nrwh9FVuUS4lZcr7VcePQ32AeLtWzZEqvVyurVq0lPT e3334rWJXrjtAZcPD2Z8bSpSxdupSlSxezqCzvdCbKnKIo120t54/ zmcwGGjevDnZ2dlERERw vRpzp8/f1urgAlxI7d8u9F8j9R4jIGjA9kasZ6F/zunoKztk0/cdnDi3mCz2YiMjLylfXX6W19SXVEUatasSWBgINHR0Xz88ccoikLt2rXlfuGVSP6851thNBpv bg6nY66desyePBgNmzYwMyZM9HpdLi5ucn9wiuRrKysWz7/HB0dS7ytkpGRUTCrOS4uDm9Tu1s6qBC3Q7WppO5IlCQryoXFYiExMbFUa1sLcafk5OSQnJxc7Nr Wt96sEUIIIUSZUCIiIuR YUIIIUQ5cnR0LLZlfU03 IAHJXcD6DSN4d9uK 8wKg2DwcCw1/5NuzM/l3cod4zRauOV6O3lHYYoAWdnZ/oPH0bnjGM337icOOfk8tKGXeUdhrgLqlSpwogRI3j44YdvuI10gwshhBAVnCRrIYQQooIzxMXFl XcMQgDgpOhIdv1XeYdxZwU1K 8IRAn9rdrKOwQhbkimbomKQQP92UwaN25c3pGISih/SUxvb /yDkVUQhaLhdTUVLlmLYQQQtzLJFkLIYQQFZwkayGEEKKCk2QthBBCVHCSrIUQQogKrkTJWosNZ2 z/D9iaehtH0jT2zx/JytjbqENUMirW3GSWvGrCZDLRrUcvglellHdQ4r5nIeviBj402c87U/fePD8hglRbDpcSFjPm QlE3s53oRC3oATJWiMxcQ9tO9dl80ZZp1WUFRVr7mFWvjmJ/U8twGw2szF6Hc diWbnHT WjdwsMyF9596FusW9yYhz1d5MNZvZ O0KRtVYyf tPU2VNv/DZ9/OJsCrvOMTlc3N17PWfuJorC N1zSDAcnsD/KhNUDqemZvrE5Xwli2C1B8eTliBK21eFZMvEBj3wSWrTqNorjTY ZUTPWLVIqWsp4570RxBlCUDrwUMdxerxAAqoqacoCfDC8TPKgBAHqjka7jx2LNSWbJmHGsOAnoj TiZ3iZmfCcs2duZ0y8eW dd7P6hIUM eRXti89Jd1WJjTvLs29HEeR7iOVjxrPiJOgdnHn2rW95o72ZkL5z2AF81 N71gaGMi/vmEIYDQ480bIji46mk3XxBF8MP4pPZDBPZF8iaflYJq1OA6MLVbtPIDLoCbIvJbF87CRWpxlxqd qdCZFBdC7vFyHueTdN1truZBI6N2OI0h46h3M0dgStOwMasCuco8HhhAbZu7i/j3yG1v5A2jq 951MaIQHp775kHmb4jG9cWWdWE1Lw/zVb3SNDKc1GlrsIsZ/Fk/rMbJgu8ijaWhnM0jz8KFo2tRhcGzGK1 ZeQUVa84RVk0IY1VKJ/zdbGjKD/xW/3M2vVcfa85hlpPOHqe32bzRD1tuFttC3yWx6wLMA qRc hrxk ex4/RwUyM1uMwMJn20ePwK6eXLComizWXH5Li8KzXCzhtL7Rlk3U8mq8zh2I2d8aSeZHtC4Yz//s2DFN38XO3hZil S3uoJska43ExHjatBoBQKtWPixPjGdIZx9QgHrP0bkzgEKrVr4sTzxv303xpWuAJ6Dh3qI1deN/J71Ivee5cPJHNgX8yDL7Dij1apMOuN/JVyfuWaqmcfzsKeA6P BsFrK/m0Wf2TsAHQYHbwIB0KM3dOWFQQ0AFVAwGBowpK8foKJpJ7iQ0ZUX3ranf4N3AM91HkjCzmA6tL/2MKIys5B1cT3TTOvB6EzVbhOJ7O9F1sW8ZK2q2NJTORCzGFOMvUjvVIWmriehwYNcmjeRCYQwWx K2uEOKT9baTxzdpbFv1wj2zcsrU7jSFX5LNEj9nXP1nmdsSC9JzuK6dIpCw1ruaHvPkgKFWtc2L JadzP/cicnmLXTMa1nfnIaqZpBxElzvWtTi/pF3zToyuFAXtqXgL5tN5eTff9Hi1YXXSchN CJiEEnL3 a5gEbSDS7uiGIHmGm7k0noMpLQyHD7v4jJ9PCI52gs9m7wk1HExkL ILQ6dWrm7biH7yPTQIP0A/s5416tUFJWwKsJzVjHbhkZLm5Er0fv15OB1mV8ljcC3GbJYVtIMFcGhGtoWgZnTpSoQvT6TrTo D1rV6WAasX6cyRRsU/SRvq9RSnpjQa8GrfCsmoj1/sa0ztVofngTxjTMZ3zMnJc3AHFtqwLd4EDoHjg7evK5sR4hvQEPH0gagRj5wH1 jE2yBO084AvtTOmM7Z//uAxH9C0K9UonphG9WXOO3n7Kgqug95jvL/nXXmR4l6kw DwL14MDeJ079GYFoHO4IB34KfM9XbjO99PmG7aik5XD6 GjniUoEa9gwNPBr3B3r72 uwDzKLxA2z6TjTzmcVHMsBMlITeCecmLzC0 1gmmUyAHqcqTRky/X9p8ONVg86kJ1zcAbe 6lbqemZ/CQNCehftytbiWTEgmcYRI2R0tyg5WXVLlCNZdUuUJ1l1SwghhLgP3Hye9Y149WZCyHXKFR GRMgULCGEEOJOkZa1EEIIUcFJshZCCCEqOEnWQgghRAWnREREaIULZDSuEEIIUbZ0Ol2xo8ENHT t2LHgQFxeH5lqlLOISoiiZuiXKkUzdEuUpf pWcaQbXAghhKjgJFkLIYQQFZwkayGEEKKCk2QthBBCVHCSrIUQQogKrgS3G9XYP38ky3blPVTc6 DHzfZ6VlWTEXWXDkvMds3rPZgcAeoxOJt6OGY saCnuNkvWRbbODuDTXXocqzQlMGQ2/eU7T5Sjm7Ss7Yl6OYXWtJ7ZhoMb48smOlHJ6TE6dmey2czmjVG82SlvLWoh7iZLFpk7viT84igW mmOIWNmTjA3XW7VaiLJTfMs6dQPfn 7HmyGFFubw6s2EIMhP5EfxZd uPdQdNJnxNb9j3Lw99u0UN3rOfB9TfY39n03j95atOTg/ijOF167WNBI G8nyXRRZ01rT9rCyfzj7UFAe78ebs3oVXYZTVEo6RYd77QaADUv2d8zqM5sd6DA4eBP46Tz6e2b z3aw zN4B6Aw4eAfy6bwB1Ms5wtdvfk66q8qOHacwOHoTGDqPQY/nkmUOoe cHegMjnjLOtbiGkacnbsSHFy4tQ3onajSNJCQ2c/jeimZyCnLcXp9NgH1srmUHMmU5U68PrMn1bfMJmBeLHqnKjQN/Jjp3S xfOwkVqcBDi483G0iEUEdyP4nkeXj3rGXAw4uD9Nt4ipGtbhSbi LIKhDNv8kLmfcO6tJc3iAR7pPYM2YTuX5JokyUGyy1s6eI8OtWbGJct/pWoyNDM/bZgShnUfY940NZ/ymeExvtEfjVzbHtOXNyDDcUjYw991t7PcfRqvd/2FH3cmERnqiaScxv7WUrS2m4J20FSU4nNDOd x1inuSDUvOZqabNlPQDf4W2CxWdn22kfoLzLxX30rOkVVM HwVbeYNott7Zrq9BzZLNttD xO9cwDBvho20ol3fpstm3w59PV4JsdsJ D1Gqzd5Mxks1m61sUVRgecOj9N77WTCOq7mm4TIwnuDEbnqvSaYqYXYMm8yPYFw9kY zyjWl2vEis5Oals2PEwU81mCn VjQgzMwIb2f8cJPL9lUQebc0z6TvZ0ux9zF 05u/tCxl5zIfX22ZyeO1qMgPNmDvlkvn3dhaOnM/3rf8HNfYY3RaaCZCu Uqj2GR9 vwZoBlgT74FreZ6/Rgb0gtQaNu395VkrqWxdeJ0NuX9OlT87PsqQNu 9tax5tWEZp77 T0V0s/9yq rpzP267z9FYV2Z8GtRh32zh8JShiD5QdjJZbXDb5 PH42C9nb5uIfvJIas5pxOuUIK0abWJS/nZOJDNWKHljBm3gpOA3uiEyQdAwWBowOA fuh0Vhq18sUj7Dypii P1djKrL5A9DhJ2CKPHscqbRgetpHBF7cy 8W BOyfSOQb7bmUtJyxk1aRBhhdqtL9hqsBG9DpPHjooc3MDgAig wJ25LJxbzWNuhxerAZgTeowabaSE9NImaxiZi8uJwebIbrCaj/4D/Mf stmDVLEnYlUWyydm/ZhjrxF0gH3DvntZpT1zP7y ttrZH zX856DuZ0Nme9pZ1UjGVa/DH2V9pFxzO4Gta0CMI7TychM9GMi5ausEFoNeh79IGv8/2c0arwW9nuzPZXHiwmYo15wirvkqk6wIz/T3tLesDxVXp4Ez39zbQNcvM7B69WSvd4KIII85Vn2XC1zo e2Uty/0ehOVHeXahmX517C3rn4vb26UqvadG0fXiFkL7PE9U4EdMM50mbMnDTDVvpl1eyxqdDv1jVXk45 gNMMXkJfFYHVNtB/v67Ja8uDLk2ITf9gjUDEln2Tj8GeEs3eGVQ/ACz k1prq3j0/mlHVCm5bXK8x/BvugNpKNB6mGS0 pSrQG0aumTV34dikLrN96lO f4o5RHF/chm4ptVwI7H3fHVd JlsUONlPR1BTOXvfEupoeB8dnGD/7RcjIuIMBi3uVLecSySsnMC8W 3mXeoEzejdqFSRMGzY1lXOnAfTodfWoUTeNjLNgyclhx4bVpBXUZsSlyjMEz gPGWcLHUVFtZ0jIw1sFgsnjx j2ftmzObNxKwNIcBLj9HohXfLXFZv3H2dKPU4PdScwTPfoMPpcxR/V2lxPyh gJniybOzw6g2fyRjA8IKiusOmow78HvRjXFv0Qbemc7YVYCnG64e c9otHE7S2jASHtXd1AYrQE6D2dI0khCA761b6d04KU1w9CuHnR2x16uuLdcuWY9HQWDQ2MCP30b b6ON sFB7O0zGtMiQG/EyfQ2UcG tGiTxbjR3Vis0/F4A29u3ENoIzdrMzP6zrEPUnP0JjB0SNm9NFFh6R0d8er1FOsCTJiwX6vuNjGSp4yXSGp6kUmvd WeRXk/9Rk1pBBgdHXniqe5ETDLRx2jEs OTeJJL5sX1TAuYRyx6nPKmfxmNF/FuHsI000b0ek8a/OtBHtfrcX/oQWI yOvu1jvxYLNAZoU8T9PnX6bbuHcwmfLLX2La1PrsyR909sAjdJ wppjzXNwvlIyMjIIlMuPi4vA2tbuzR9A09n82ip9bhV2nu1uIPLLqlihH5bnqVm7m32xfOJJjPh EEdboy8Mxp9HW6v8V9KX/VrWKXyCzDeIQQQlzFwdGJJ/y6EfmOvSVfMKVLErUo5O4na0WhdX63txBCiKL0TjzYdgRh5hHlHYmowOTe4EIIIUQFJ8laCCGEq OAkWQshhBAVnBIREaEVLpDRuEIIIUTZ0ul0xY8G79ixY8GDuLg4NNcqZRGXEEXJ1C1Rjspz6pYQ VO3iiPd4EIIIUQFJ8laCCGEqOAkWQshhBAVnCRrIYQQooKTZC2EEEJUcMUnay2eFQEjGJv/b J6 3KWWjwr oezv0xCFJWXijU3mSWvmjCZTHTr0YvgGy6LeZcisOZwaPmYMj uKG82ci4lsGik/dzr3vt5JkTcaLSuhcyLW5kdMJ/YMo1RVCY3b1krvrwcGU5oZBgvu61jTWTaTXcR4vapWHMPs/LNSex/agFms5mN0et47kw0O8s7NHGfs5FzKYmV70zn6LMLMZvNxESspGfGBknGotyUohtcoVUrXzIyzhc tTl3P7PwWNxrpkR8wOzINtDS2TviAFfM/YGzACMb1n8bWlD32lnr/kcz5RpK KIaqoqYc4CfDy4wZ1LDpi3kAAA3LSURBVAAAvdFI1/Fj6ZhziOVjglmVAqhWcg4tZ0zwKlJQseYks2RUXmuoZx/mfG8h 7tZ9JljT/G23CzMIX2Zu91KzqFlvPbvGcwYZcLUrQe931jGwc0zMJm60aN3Xv32YMjNjmOGyYSpey/6zrXXpVqyObB4FKbC5aqF7ORljP73DGaM6k6vvnPlx8W9xmbFknqUg46D Xd/ 9JXRmdnuga/QftCrW1Tz cImH9V rZlcylhKcEB84nFRvalBMLztu/5XADzYwFLJhfXT7Ofo31eYGJk8fNrhYBSJWuNxMQ91KlTsxR7/EqC0p3QiDCCB2hsfncrNT4OY 5Hz8GqbdKNLm5M09DOZpDmUZsGJdxFtVo4uuZLvmk0GbPZzOaNMYz3K24HG5yOx3nIFjZFf0KAd SXvbqrP55ui WSgjZUxeUnZqpK 9k86mTezYW0wHbd/y pjFnKPf8Piv4bYjxUdwRjbHObuBFRrXr2b2RA9juJCEBWQqmL77Ryn3WpRdJVKPY5V2jA8zIzZv JmYNR/Q72QUBbnWls2lpDW8N/NvAiKDeCI7i PRX5M51IzZvJHIpaPInRfKdzmpbNjxMO bzWyOWUuILFotSuDmS2Rqe1gWsIdlgNJlJHMDPEE7f9PdABTFjR49fEDRcK9VF7o0w SloGnVqUXJ6hCVk6ppHD97CvAp8T6aBr d0zOkXwnTo86AwWswffx0KLkNqFvfSNf2g2ik5JJVywMu5G9mwGtwH/zQYzN0onWXz0k o6HmpnF40xJMm6bbtzM60dg1BaoZMTQYQh/J0vckm2oj9dxprnvuWbK4uHU2AZ/uAvQ4VWlKIAC5ZF76ngXTmxIYMpvOgEW1kZ56gJjFJmKgYPs6Jzx46KHNhPQHIoLoVFYvTNzTbp 6sFV9ejhgh61GLMqVTFBrWckfbe5YUKEHrWkVTUzibXhaLtIOqqfzy 3majFjApwMLRadayD4sfUb3Mr1Oj1f1utgOniMVCrWuLWRlxhK2 CGmmjfT7lIykVOW5z3ngIvLk7z6moElG2MJCHoCm3qSv/9qwasLZ3NN47l5FF3/3kJonxeICpwlrWtxU7c/dat dWqnneN3AO0nYledvu0qhUCvR /Xk4HWZXyWd/HYZslhW8hYVv/iRS23E5zJAJvNyo6YFZxAh07fgBbtbayILnSVWFFQatXBM/0sKaoV68 rWbujdKGoNpVffkwgBRs2627273ocN1c9DZq1w7oiRq5J32 MDjh1fpq OSv5v7wR4JasS3w3dwJXBoSrqLazZBQeemN0waXTSIZnz2VC5EmMBi8at7KwauP1hqUZcXnwGYJ mBEDGubv8gsT94PYbIUp7Og/cTGjACJbhRtsubncgLCF0GBz xYuhQZzuPRrTItAZHPAO/JR53gZybP6sGWeip15PPb neBzQGYw0HvAq/mPGYTJNR290wvR2DG8 EUDvGn0Y3W0Jen1nnny6dJHo9fBEq2xCTN05ZXSiceBc3m5kRLX0Z TzQUwwmZiODqNTYwJnh/DcXXk/RNnR41ilOYOmj2B2wGuYvgK9YxWaBoYw81/V2doihGmmTej1njRoXIXHC 1pdHHB99VRJL/yf3zb8hN6vzCU7mMnYTIBeieqNH2RD6Y8xLqAecSix nBZgTOGlxeL1TcQ5SMjIyCJTLj4uLwNrUrz3hEZSWrbolyJKtuifKUv pWcUtkyh3MhBBCiApOkrUQQghRwUmyFkIIISo4SdZCCCFEBSfJWgghhKjglIiICK1wgYzGFUIII cqWTqcrdjS4oWPHjgUP4uLi0FyrlEVcQhQlU7dEOZKpW6I85U/dKo50gwshhBAVnCRrIYQQooKTZC2EEEJUcJKshRBCiApOkrUQQghRwd181S0tja0Tp7Mpfyk4Wd 9alBkVa 5hlo8Zx4oThVbdGnS91a1tWLK3E9r/AD4x4/Er/Iwlm 2h/TngE8N4v vsKoQQFVzxyTovUR/0nUzobE9AIz1yGqET11MtpDfuZROjqJTsiXrlm5PY/9QCzF82wGaxsHP fHZSNBkLIcT9rthkre3 jk1KP8YGeOaVKLj7B9Jjz3/5ObU37qxn9v dozZ72HfKl5fXNONo/zD25W3t uJkxvt7oMUuYlwitN21h30oKH4jmDvGBzSNhM9GsnxXfvUKroPeY/wLHlfK88v8Pa8NUNy/VBU15QA/GV4mOK8lrTca6Tp LNacZJaMGceKk4DeiJPpbWLGdwJAs Zycskopq84hcHBm8BP59HfE9Cs5J5cwqjpKzhlcMQ7MJTQAHcOLR/DeHtFODg/y1vR4/Cz5ZJlDqHvnB32WHQGHL0DCZ37AnXNITw3ZwfojDg1DmTupwO5XjtfCCHupGKvWZ8 fwbFrXrRFrTiQTX3X7lwFtCAtHh4LpzQiBG0VnwYEhlOaGQ4oREjqbVqG/uxb6fEZlDj43DmRgynza4tmFM1tNQN7Dj9PGMjw5g7sx unv3o7Btvs/7Kg7mdDIcOaufpdme5ZiLn6 uLjfaBra2QzSPGpflQx1GByb8cpXZszmLWyKmsXAtLWsSgGwobKbRKeJbNkUzaxBNlZE7wTApsL uRCcmbtlE9CcDsa2MIdbgSPNXvsJsNrNlUxSfDDjJ2lXHsFqP882G3xi YAub1ocS2LAhL73RHw9rLAs2e7HAbGbL rV81DaOL1anlP17I4SodG5 zbo4ClDvOTp3zi/I6yZfddr tNKBxvnbdemGyQvQfGjceRE/nwVqXadODdLP/cqvq6cz9uu8wyg62p4DvG4rWnEPUTWN42dPAT7XPmmzkP3dLPrM3gHo7C1oAPToDV15YVADdKqV hq188Qw7Swqg1xvo sIgGuhUrI1a4esRxtkUG7muZkL6zmEHoDM44h14w4DQjp3m OEVjDaF28v0Djg/mwHSthZC3GXFJmu3mnXR4i QDlda19opfk93pXrP6 yQuoE18W0YG/k 7lo8KwYcKqZ2BbyqUetkOKEB34Ki0C4oDHc09p/9lXbB4QzuXMzu4r6mUxQa1nJH22tPtlfSoQ2LZSfzP3disnkLHXOOsGpC2C0dw5aby87PF A82cyWjjkcWTWBMHQoSn2q1TrCnNHdWKR3wPnZt4j2Usn6/gLnekzGPE6umAshylax3eBKp2a0PRlFbGx iUb6N/9lk9IG75u1clMvcK7YDTTYfZhzL07O6zYPsydnBVq19GFf9AbSS/wyxH1Hr0fv15OB1mV8Zu/jxmbJYVtIcF6XN4CGpmVw5kT YxuqbQf7doKq2jieuIc0d3s3uk21scP BLZjiew55UHtQg1iTVXJOHMSsGHTfuDQb8NZYDZj3ryB6HF 9ng6taDj9m Rnm8hRFkrvhtc8WFIBKzoP4Kx8/LK6vVj7I1GgtdvSnNtOqEB6wA3XOu5Fn/0WjXQ5hXu7u7ASxHDad15OEOSRtpb3CgoOl9eXjOcVqV7beKepsPg8C9eDA3idO/RmBZdmbo119uN73w/YbppKzpdPbwaOuIBoBhQPPx5bLeJbtP1GJ1MvB3jB5YcDIoH/o/txtRtOnoHZ559K5qu lyymvkwa7qJLTod9bwa4uihoKM61bI ZrRpEUDB9uM6PcmY1/fy3GgT4YXLpaEthLjLlIyMjIIlMuPi4vA2tSubI2sap775kEhlqH2kt6ax/7NR/NwqTLq/K6OKsuqWaiXnyComhBkImjeIBrZcsr6fx8Dk9vYWtrgvyapbojzlr7pV7BKZZRhPUYqCu/ z1Oqf37JWUOr1482gcotICNAZMDT0p1eNvnktax0GR28CQyeWd2RCiEqs/JI1oCi DIn0ZUh5BiHEVfQOznR/z0z398o7EiGEsJN7gwshhBAVnCRrIYQQooKTZC2EEEJUcEpERIRWuKDcR MKIYQQlYxOpyt NHjHjh0LHsTFxaG5VimLuIQoqqJM3RKVkkzdEuUpf pWcaQbXAghhKjgJFkLIYQQFZwkayGEEKKCk2QthBBCVHCSrIUQQogKrvjbjWrxrOgfxr78x8Wtu CWEEEKIu LmLWvFl5cjwwmNDONlt3WsiUwrg7CEEEIIka8UC3kotGrly/LE84AnWmw44 btsT V3 K qiXu uJkxvt7oKVsYM6X56jNHhJO5a1ZfadfiRBCCHGfKkWy1khM3EOdOs AFs/K6FqMjQzHHY30yGmsiWzKhAAfhkT62FfR0uJZMWAb /2H0QoNTsWjBIUzV9aqFkIIIUrl5sla28OygD0sA5QuI5kb4Akphzh7ch2hAesKNlO6nAc8SI cRuiq0/YypQP2 1EpKJ796CSJWgghhCi1mydrxZeXI0YU6bbWzp0jo8tIQoN8im6bup418W0YG/m vUt8wKE7G60QQghRCd3S1C2lUzPaxG5ma3G3Mk29wLlbDEoIIYQQV5TimnUhig Dg5IZN2kEm wFtA0OY0inpjTXpud1j7vhWs/1DoYqhBBCVE5KRkZGwRKZcXFxeJvalWc8orKSVbdEOZJVt0R5yl91q7glMuUOZkIIIUQFJ8laCC GEqOAkWQshhBAVnCRrIYQQooKTZC2EEEJUcEpERIRWuEBG4wohhBBlS6fTFTsa3NCxY8eCB3Fxc WiuVcoiLiGKkqlbohzJ1C1RnvKnbhVHusGFEEKICk6StRBCCFHBKZqmaTffTAghhBDl5f8DA69b EYwa4jIAAAAASUVORK5CYII=
30798
Is this possible with PowerQuery? If so, any guidance would be greatly appreciated.

Aflatoon
05-09-2023, 02:04 AM
You can do something like this:


let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Type", type text}, {"Name", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Type"}, {{"Data", each Table.AddIndexColumn(_, "Index", 1, 1, Int64.Type), type table [Type=nullable text, Name=nullable text]}}),
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Type"}),
#"Expanded Data" = Table.ExpandTableColumn(#"Removed Columns", "Data", {"Type", "Name", "Index"}, {"Type", "Name", "Index"}),
#"Pivoted Column" = Table.Pivot(#"Expanded Data", List.Distinct(#"Expanded Data"[Type]), "Type", "Name")
in
#"Pivoted Column"

enjam
05-09-2023, 03:05 AM
Fantastic, thanks very much! Just what I was after.