Created a Comma Separated Value (CSV) List from a One Column Table or List
Sometimes we have a proper table or list of data but want to convert it to a delimited list (i.e. separated by some delimiter like commas or semicolons). If it is just a one column table it's not that hard to do this with transpose and then some concatenation. However if it's a multiple column table it become a bit more involved...unless you have Power Query. Now PQ makes it much easier to do this with a couple steps and some small samples of M code. See the video to check it out. ENTER DESCRIPTION HERE 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html 📚 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" https://www.youtube.com/watch?v=COUOvhbQ4CQ -~-~~-~~~-~~-~-
Download
0 formatsNo download links available.