In the Excel worksheet, the list of personnel is stored according to the company department. Each department occupies a row, and the number of people occupies as many columns. How to achieve? In fact, using the Excel auxiliary column, plus the help of Word's search and replace function, such an operation is still very easy to achieve.
First, insert an auxiliary column on the right side of column B, enter "=B2&","&A2" at C2, fill down to C6, select the C2:J6 data area to copy, open a blank notepad, paste, and then copy Select the data pasted into Notepad, cut it, open a blank Word document, and paste it.
Then, click "Replace" in Word, click "More" in the pop-up window, position the cursor to "Find what", click "Special Format", select "Tab"; position the cursor to "Replace with" , click "Special Formatting", select "Paragraph Marks", and click "Replace All". In this way, multiple columns of data become one column.
Next, select the content in the Word document, cut; switch to Notepad, paste, and then select the content in Notepad, cut; switch to Excel, create a new worksheet, select cell A1, and paste. Select the data area (ie A1:A26) in the worksheet, select the "Data" tab, click "Columns", select "Delimiter" in step 1 of the pop-up window, click "Next", in step 2 Check "Comma" at the separator in the middle, click "Next", and click "Finish", so that the column display of names and departments is realized. Enter "=B1" in cell B2, select cell B2, and copy; select the range of cells B2:B26, select the "Home" tab, click "Find and Select → Targeting Conditions", and select " Empty value", so that all empty cells in the B2:B26 cell range will be selected.
Click "Paste", and the blank cells are filled with the corresponding department names. Select the data area of ​​column B, copy and paste it to the original data area, and select "Value" when pasting.
Finally, swap the data in columns A and B by cutting and pasting, insert a blank row above row 1, and enter a title. In this way, the effect of turning multiple columns into one column is completed.
Fiber Optic Ip68 Enclosure,Ftta Ip68 Hardened Connections Device,Ftta Ip68 Hardened Connections Fast,Fiber Optic Ip68 Enclosure Adapter
Huizhou Fibercan Industrial Co.Ltd , https://www.fibercannetworks.com