Changing of data base format

[Krzysztof]

Hi,

I have the table

I would like to receive this format of data:

Any suggestions?

[ppr (Peter)]

@Krzysztof
lets build an empty datatable with the target structure:

let retrieve the company column names for a later lookup:

lets do the detransponation with following LINQ:

(From d In dtData.AsEnumerable
Let mr = d.ItemArray.Skip(1).Select (Function (x, i) New Object(){d(0),Companies(i), x }).ToArray
From ra In mr
Order By ra(1).toString
Select dtResult.Rows.Add(ra)).CopyToDataTable

Line1 - iterate over the data - refernce looped row with r
Line2 - create the rowArray for the target rows:

• skip(1) - omit name column
• iterate over the remaining items of ItemArray and create an ObjectArray - return all as array

Line3 - iterate over the result of mr
Line4 - order it by the company name
Line5 - add the item to the target datatable

Result:

find starter help done with a LINQ here:
Datatable_DeTranspose.xaml (9.8 KB)

[Krzysztof]

How to add variable type String? I have never used it so far:(

[ppr (Peter)]

on variable panel:

2nd step:

[Krzysztof]

IT WORKS! THANKS A LOT!!!

[ppr (Peter)]

Perfect, it is working
take your time for doing the final testing. May we ask you to mark afterwards the solving post as solution. So others can benefit from it, when a similar case is researched.
Thanks