Sometimes we need to split data from a long column into a table with several columns based on some criteria like X rows or X columns. If we split data by manual, it is very complex and troublesome. So, we need a simple way to split data into multiple columns. This video will introduce two methods to split data, one is by using Excel SEQUENCE Function (Office 365 Subscriber). The second way for any version of Excel by using ROWS/COLUMNS & INDEX Function.
#Excel #SplitData #MultipleColumn
Негізгі бет How to split data into Multiple Columns
Пікірлер: 14