Use Power Query to Convert a One Column Address List
Have you ever received a bunch of address in a one column format and needed it to be broken out into a table format so you could do a mail merge? If you had a 2 or 3 address that wouldn't be a problem to cut and paste to different columns, but if you had over 20, 50 or over 100 addresses that would be a chore. With Power Query, it become so much easier to do this, so check out the video to see how.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~
Смотрите видео Use Power Query to Convert a One Column Address List онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Doug H 10 Апрель 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,223 раз и оно понравилось 126 людям.