Hi, I have the excel with single column as per below. Apr May June 0 23 0 77 0 6 0 -12 0 1 0 8 I want this to to be three separate columns for Apr,May and June and the values also should come into corresponding month instead of single column, Sample Output should be like this in ex…

How to split the single column into multiple column

asatheeshk21 (satheeshkumar) January 8, 2020, 6:44am 15

Hi,

Requirement got changed. Can you please see this. I have opened one more forum. It will be helpful if could share ur ideas .

Topic		Replies	Views
Split single column into multiple columns Studio	7	2306	November 24, 2022
Transpose multiple rows into single column Activities datatable , excel , activities , studio , question	9	229	January 14, 2024
How to separate multiple merged data in 1 column into individual columns? Studio studio , question , activities_panel	5	810	June 28, 2022
How can you split a DataTable into its columns and without hard coding variables? Activities excel , activities , question , data-structure	3	1267	August 1, 2021
In excel automaion how to split the columns data Help studio	2	1274	June 29, 2019