E
Eskimo
I am trying to import multiple CSV files from a folder.
Each CSV file have all the same structure whereby there is redundant data
that I don't need in rows 1 through 21, Except I need a number that is always
stored in a cell lying on Row 8 and Column 2.
Then the rest of the data I need. Row 22 is all header information, and
anything below that I need to import for analysis.
The twist is that the number from Row 8/Column 2 should be included in the
list imported from row 22 on. ie. for each line imported from row 22 down,
throw in that number on a new column for every line imported.
I hope I make sense there.
Thanks
Jonathan AKA Eskimo
Each CSV file have all the same structure whereby there is redundant data
that I don't need in rows 1 through 21, Except I need a number that is always
stored in a cell lying on Row 8 and Column 2.
Then the rest of the data I need. Row 22 is all header information, and
anything below that I need to import for analysis.
The twist is that the number from Row 8/Column 2 should be included in the
list imported from row 22 on. ie. for each line imported from row 22 down,
throw in that number on a new column for every line imported.
I hope I make sense there.
Thanks
Jonathan AKA Eskimo