How to split the single column into multiple column

[ppr (Peter Preuss)]

@asatheeshk21
have a look here:

Transpose in Excel by Rules

@Atakan_Kiziltan As an variation to @Lahiru.Fernando with the same Idea of segementation Assumption: each segement has a length of 5 values and is complete otherwise we have to handle additional First step preperations Prepare the dataTable for the transposed data: [grafik] Second step: bring all values into a list and filter out empty values: Assign Activity: dtData.AsEnumerable.Select(function ( r ) r(0).toString).Where(Function (s) Not String.IsNullOrWhiteSpace(s)).toList Third St…

its a similar situation just change the segment size from 5 to 3