![]() To split the data in column A to column B-D separately, the first thing you should do is giving Excel an example.Įnter the first data of the first row in B2, which is “ 1“. They can obviously be divided into three types: serial number, name and score. In this table below, all the data are stored in column A which looks very messy. I’ve introduced the method to split a column through Text to Columns in previous post, here I’d like to share another way using Flash Fill. But if there’re tons of data waiting to be processed, you must want an easier way to save time and effort. You can of course split the data in a column into different columns manually by cutting and pasting. But sometimes the data collected by others or uploaded from a TXT file may not be organized that well. ![]() Making a table in Excel requires you to put different types of data in different columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |