Merge multiple CSV into single excel

Yash_Nagda

I have nearly 2000 csv files. each of them contains approx 700 rows, but I only need first 18 rows of each csv 
the first 18 rows contain data like :
Name,Adam
Age,17
City,Amsterdam
.

.

.

So On...
I need an excel which has there 18 columns as headers Like Name, Age,City...etc. and the excel file should contain 2000 rows i.e. the info from each file 

I am adding some 3 or 4 demo files for reference

64917.csv

64923.csv

64922.csv

64919.csv

DataNath

@Yash_Nagda is this what you're looking for?

In terms of the steps taken to achieve this, I:

1) Placed all CSVs into a directory and used a wildcard to bring them in (the *.csv part of the Input Data configuration):

2) Used 2 sample tools to a) skip the first row of each file - containing the version # and b) isolate the first 18 rows of each file:

3) Split the CSVs into their 3 columns using Text-to-Columns:

4) Cross-tabbed the data, using the newly-split fields as headers/values and grouping by the filename to stop them becoming aggregated into a single row:

Hope this helps! Please let us know if you need further assistance.

Import multiple CSVs and transform.yxmd