Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tabular Format to List Field Value

Hi Team,   I have table data in below format  FieldName Value FirstName Atul LastName Kumar Age 28 Designation Programmer FirstName Tony LastName M Age 32 Design...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Pat,

     

    Thanks for your time and reply. Appreciate your time. I got the desinred result using simple Table.FromRows function.

     

    = Table.FromRows( List.Split(MyData[Field_Value], 4) )

    = Table.RenameColumns(Source,{{"Column1", "FirstName"}, {"Column2", "LastName"}, {"Column3", "Age"}, {"Column4", "Designation"}})

     

    MyData is the table name and there were 4 repated colum values in Vertical table. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pat,

 

Thanks for your time and reply. Appreciate your time. I got the desinred result using simple Table.FromRows function.

 

= Table.FromRows( List.Split(MyData[Field_Value], 4) )

= Table.RenameColumns(Source,{{"Column1", "FirstName"}, {"Column2", "LastName"}, {"Column3", "Age"}, {"Column4", "Designation"}})

 

MyData is the table name and there were 4 repated colum values in Vertical table.