Hello,
I know I am going to spend hours if not days trying to figure this out (as I have in the past), and probably end up with nothing. This forum has been extremely helpful before. Here's a problem I've currently run into, and hope someone can kindly assist..
Current Data:
File 1:
Each set of data is listed in either two or three rows
Eg.,
ID
Date
Filename
ID
Date
ID
Date
Filename
The goal is to move them to separate columns (rows can be 3 or 2 for each data set, and may or may not be separated by space/additional row)
File 2:
Has a common field 'ID' as that of File1, does not have Date, and Filename, but has a new field 'Detail' (already in the expected format)
Eg.
ID Detail
The goal is to merge properly formatted data from File 1 to File 2
Eg
ID Date Filename Detail
I'll be happy to clarify further if needed. Sample data attached.
Many thanks in advance.
Bookmarks