So long as the number of rows is known, it only takes: a regex to split the string on comma-spaces which immediately follow a one-or-more digits or a word starting with an uppercase letter, a call of array_chunk() and array_map() (with a null callback and data spreading) to “transpose” the data. Code: (Demo) $string = … Read more
Assuming that your table is called df and the columns of your table are named X1, X2, X3 try the following: library(dplyr) library(tidyr) df %>% spread(X2, X3) 1 solved Conditional columns to row [duplicate]
try this, create table #tmp (MR_ID varchar(50),DR_ID int) insert into #tmp VALUES (‘MR_123’, 1),(‘MR_123’, 3),(‘MR_124’, 4),(‘MR_124’, 5) ,(‘MR_124’, 6),(‘MR_125′, 0) declare @DRCol varchar(50) declare @Prefix varchar(20)=’DR_’ ;With CTE as ( select * ,ROW_NUMBER()over(partition by MR_ID order by DR_ID)rn from #tmp ) select top 1 @DRCol=stuff((select ‘,’+'[‘+@Prefix+cast(rn as varchar)+’]’ from cte c1 where c.mr_id=c1.mr_id for xml … Read more
Try this code, but before you do adjust the two constants at the top to match the facts on your worksheet. The worksheet with the data must be active when the code is executed. Sub TransposeData() Const FirstDataRow As Long = 2 ‘ presuming row 1 has headers Const YearColumn As String = “A” ‘ … Read more
As direct answer, you should read file line by line, process them with Text::CSV, push new values to arrays with each array corresponds to original column and then just output them with join or like to get transposed representation of original. Disposing of each array right after join will help with memory problem too. Writing … Read more