T
tdking
I need to interface with a program that generates a .csv file with row
of data.
It generates 2 or more rows for each instance uniquely identified by
the docket/page combination
Example:
last first bank trustee docket page
smith john ny bank (blank field) 12235 8907
(blank field) (blank field) cal western 12235 8907
smith janet ny bank (blank field) 12235 8907
I need to consolidate all three lines into one row by concating field
that contain different data (first name column) and columns with blan
spaces to look like the following:
name bank trustee docket page
smith john smith janet ny bank cal western 12235 8907
Should I consolidate the data before importing it to excel?
And what would be the best way to do that?
Should I do it after importing and what would be the best way to d
that
of data.
It generates 2 or more rows for each instance uniquely identified by
the docket/page combination
Example:
last first bank trustee docket page
smith john ny bank (blank field) 12235 8907
(blank field) (blank field) cal western 12235 8907
smith janet ny bank (blank field) 12235 8907
I need to consolidate all three lines into one row by concating field
that contain different data (first name column) and columns with blan
spaces to look like the following:
name bank trustee docket page
smith john smith janet ny bank cal western 12235 8907
Should I consolidate the data before importing it to excel?
And what would be the best way to do that?
Should I do it after importing and what would be the best way to d
that