Excel Tip: merge multiple columns into one column
The title of the original text: "many columns are merged into one column, this Excel trick is wonderful!" "
As soon as I was about to get off work last night, the boss sent me a "task"-to convert the names on this list into a list of forms!
╭ (╯ ^ ╰) ╮, don't make me work overtime!
Procedure:
❶ selects the data and copies it into the Word document.
❷ in the document, click anywhere on the list, click "layout tab" and select "convert to text".
❸ in the "text separator", click "paragraph mark"; finally paste the data into the Excel table, done! Multi-row and multi-column data is listed into one column!
Have you learned this little trick?
This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Tian Tian
