Tranform data from Rows

[Almaz722]

Dear all hi, 

I faced with problem in data preparation for our dashboards.

I Have dataset like this.

Name Value

A	X
B	Y
C	Z
A	V
B	O
C	B

and i need to tranform it for propper calculation like this:

A	B	C
X	Y	Z
V	O	B

Could you please help me. 

Thanks a lot, 

Almaz

[slorin · Accepted solution]

Hi

= Table.FromRows(
     List.Split(YourSource[Value],3),
     List.FirstN(YourSource[Name],3)
)

or

let
  Source = YourSource,
  Group = Table.Group(Source, {"Name"}, {{"Values", each [Value], type list}}),
  Table = Table.FromColumns(Group[Values],Group[Name])
in
  Table

Stéphane 

[Almaz722]

Hi, Stepane. 

let
  Source = YourSource,
  Group = Table.Group(Source, {"Name"}, {{"Values", each [Value], type list}}),
  Table = Table.FromColumns(Group[Values],Group[Name])
in
  Table

Thank you, this option works greate on test excel file, but when i want to do same on CVS/TXT file, it is doesn't work. Also, as i see there are two options how steps in query marks. When i work with CVS/TXT steps starts #. 

[ronrsnfld]

If you are importing from a CSV, did you remember to promote the headers? (Use First Row as Headers)

[Almaz722]

I fix issue with CSV, Thanks Stepane!!!