Class PivotUse the Pivot transformation to pivot your data. Example:Month,MonthValue Jan,100 Feb,200 Mar,300will become#Jan,Feb,Mar 100,200,300InheritanceobjectLoggableTaskDataFlowComponentDataFlowSource<ExpandoObject>DataFlowTransformation<ExpandoObject, ExpandoObject>Pivot<ExpandoObject>PivotImplementsIDataFlowTransformation<ExpandoObject, ExpandoObject>IDataFlowSource<ExpandoObject>IDataFlowSourceIDataFlowDestination<ExpandoObject>IDataFlowDestinationIDataFlowComponentILoggableTaskInherited MembersPivot<ExpandoObject>.MaxBufferSizePivot<ExpandoObject>.PivotColumnsPivot<ExpandoObject>.PivotValuesPivot<ExpandoObject>.PivotRowsPivot<ExpandoObject>.KeepEmptyValuesPivot<ExpandoObject>.ColumnNameGenerationPivot<ExpandoObject>.ValueCombinationPivot<ExpandoObject>.ValueAggregationPivot<ExpandoObject>.SourceBlockPivot<ExpandoObject>.TargetBlockPivot<ExpandoObject>.ProgressCountPivot<ExpandoObject>.PrepareParameterForCheck()Pivot<ExpandoObject>.Reset()Pivot<ExpandoObject>.CheckParameter()Pivot<ExpandoObject>.InitComponent()Pivot<ExpandoObject>.CleanUpOnSuccess()Pivot<ExpandoObject>.CleanUpOnFaulted(Exception)Pivot<ExpandoObject>.LinkErrorTo(IDataFlowDestination<ETLBoxError>)DataFlowTransformation<ExpandoObject, ExpandoObject>.TargetBlockDataFlowSource<ExpandoObject>.LinkTo(IDataFlowDestination<ExpandoObject>)DataFlowSource<ExpandoObject>.LinkTo(IDataFlowDestination<ExpandoObject>, Predicate<ExpandoObject>)DataFlowSource<ExpandoObject>.LinkTo(IDataFlowDestination<ExpandoObject>, Predicate<ExpandoObject>, Predicate<ExpandoObject>)DataFlowSource<ExpandoObject>.LinkTo<TConvert>(IDataFlowDestination<ExpandoObject>)DataFlowSource<ExpandoObject>.LinkTo<TConvert>(IDataFlowDestination<ExpandoObject>, Predicate<ExpandoObject>)DataFlowSource<ExpandoObject>.LinkTo<TConvert>(IDataFlowDestination<ExpandoObject>, Predicate<ExpandoObject>, Predicate<ExpandoObject>)DataFlowComponent.PredecessorsDataFlowComponent.SuccessorsDataFlowComponent.CompletionDataFlowComponent.BufferCancellationSourceDataFlowComponent.BufferCancellationTokenDataFlowComponent.WasComponentInitializedDataFlowComponent.IsReadyForProcessingDataFlowComponent.SetParentComponent(DataFlowComponent)DataFlowComponent.InternalLinkTo<T>(IDataFlowDestination, object, object)DataFlowComponent.AddAutomaticVoidLinkToOtherTargets(DataFlowComponent, IDataFlowDestination)DataFlowComponent.ResetComponent()DataFlowComponent.InitBufferObjects(CancellationToken?)DataFlowComponent.InitCheckedParameter()DataFlowComponent.OnInitializationDataFlowComponent.OnCompletionDataFlowComponent.OnExceptionDataFlowComponent.CompleteOrFaultBufferOnPredecessorCompletion(Task)DataFlowComponent.ExceptionDataFlowComponent.ErrorSourceDataFlowComponent.CancelBufferAndThrowOperationCanceledException()DataFlowComponent.InternalLinkErrorTo(IDataFlowDestination<ETLBoxError>)DataFlowComponent.ThrowOrRedirectError(Exception, string, string)DataFlowComponent.ThrowErrorAndFaultNetwork(Exception, string)DataFlowComponent.CancelComponent()DataFlowComponent.ErrorCountDataFlowComponent.OnProgressDataFlowComponent.ExecutionStartTimeDataFlowComponent.ExecutionEndTimeDataFlowComponent.TagDataFlowComponent.LoggingStartOnce()DataFlowComponent.LoggingFinishOnce()DataFlowComponent.LogProgressBatch_AfterThrowOrRedirectError(int)DataFlowComponent.LogProgress_AfterThrowOrRedirectError()LoggableTask.TaskTypeLoggableTask.TaskNameLoggableTask.DisableLoggingLoggableTask.LogThresholdLoggableTask.TaskHashLoggableTask.LogInstanceLoggableTask.ParentTaskLoggableTask.LogTrace(string, params object[])LoggableTask.LogDebug(string, params object[])LoggableTask.LogInfo(string, params object[])LoggableTask.LogInfoOrDebug(string, params object[])LoggableTask.LogWarn(string, params object[])LoggableTask.LogError(string, params object[])LoggableTask.LogFatal(string, params object[])object.Equals(object)object.Equals(object, object)object.GetHashCode()object.GetType()object.MemberwiseClone()object.ReferenceEquals(object, object)object.ToString()Namespace: ETLBox.DataFlowAssembly: ETLBox.dllSyntax# public class Pivot : Pivot<ExpandoObject>, IDataFlowTransformation<ExpandoObject, ExpandoObject>, IDataFlowSource<ExpandoObject>, IDataFlowSource, IDataFlowDestination<ExpandoObject>, IDataFlowDestination, IDataFlowComponent, ILoggableTaskConstructorsPivot()#Declaration public Pivot()Implements#IDataFlowTransformation<TInput, TOutput>IDataFlowSource<TOutput>IDataFlowSourceIDataFlowDestination<TInput>IDataFlowDestinationIDataFlowComponentILoggableTaskPrevPivot<TInput>.PivotDuplicateNextRowDuplication<TInput>