Скачать или смотреть Excel advanced tutorial: Learn to merge columns and add line breaks in Power Query

📢 Microsoft Excel advanced tutorial! Learn how to merge columns and add line breaks in Power Query to make your data more readable 🤓

✨ Process
Step 1 → Select your table, go to Data, Get Data, From Other Sources, From Table/Range.
Step 2 → Select the columns you want to merge
Step 3 → Go to the Transform tab and choose merge columns
Step 4 → Choose your preferred separator and name your column
Step 5 → Select your new column and under the Transform tab select 'Replace Values'
Step 6 → In the 'Value to Find' field, type in 'comma.' For the replacement value, click on 'Advanced Options' and check the box for 'Replace using special characters.' From the dropdown, select 'Line Feed.
Step 7 → Rename new columns, then click Close & Load.

📲 Share with a friend who wants to improve their Excel skills

👉 Want more content like this? Hit the plus for more Excel tutorials and work humor