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 ➜ [ Ссылка ]

🏫 Excel Training ➜ [ Ссылка ]

📚 Excel Books & Tech Gear ➜ [ Ссылка ]

⚙️ Tools: Screencasting ➜ [ Ссылка ]

⚙️ Tools: Microsoft Office ➜ [ Ссылка ]

⚙️ Tools: TubeBuddy ➜ [ Ссылка ]

📝 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 [ Ссылка ]

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть