How to update to excel row data to excel column

[BNK (nirmal)]

I have input data in Excel. Please check below attchment.

Output - Copy.xlsx (7.9 KB)

I want to update the data to column

Expected output

[rlgandu (Rajyalakshmi Gandu)]

@BNK

Main.zip (2.3 KB)

[vrdabberu (Varunraj Dabberu)]

Hi @BNK

→ Read Range Workbook

Output->dt_Input
→ Use below query in assign:

lines= dt_Input.AsEnumerable().SelectMany(Function(row) row.ItemArray.Select(Function(cell) cell.ToString.Trim())).ToArray()

lines is of DataType Array(System.String)
→ Use For Each loop

For Each currentItem in lines
     Assign-> outputString= String.Join("/", currentItem.Split({vbCrLf, vbLf}, StringSplitOptions.RemoveEmptyEntries).Select(Function(line) line.Trim()))
     -> Genrate Data Table from Text
           Ouput-> dt_Output
     -> Append Range Workbook
End For Each

outputString DataType System.String

Sequence11.xaml (10.8 KB)
Output.xlsx (8.3 KB)

Regards