Leer multiples csv en carpeta - convertir filas en columnas

[S3rg10frula]

Hola,

Tengo una consulta que lee una carpeta con csvs que tienen el siguiente formato:

Necesitaria darle formato tabla de esta forma:

Gracias

[S3rg10frula]

thank you so much

[jgeddes · Accepted solution]

Group By your header column. Choose 'All Rows' for the Operation.

The next step should add an index row to the nested tables.

Table.TransformColumns(#"Grouped Rows", {{"All Rows", each Table.AddIndexColumn(_, "Index", 1, 1)}})

Now expand the All Rows column. You do not need the header column in the expansion.

Select the header column and select Pivot Column (on the Transform ribbon). The values should be your second column and the Aggregate Value Function is 'Don't Aggregate'.

You can remove the 'Index' column to end up with something like this...