I have an Excel spreadsheet with data. Colom A have a file reference and then contains other data in the columns to follow.
I have a 2nd spreadsheet with data that changes in a process. It ill contain the same file ref as the first Excel spreadsheet but then it will have status = 8 with a date and time and then later update to status = 1 with date and time. Both date and time data are important for me and I need to display both. However I have 2 records now and rather need to display column with file ref, then header = 8 with date and time and then header 1 with date and time and 0 if there is no data on 1 line only.
I have this:
File Ref
Status 8
Status 1
Status
230704610012
N
Y
1
230704610012
Y
N
8
But I want this, instead of the Y and N I will just add the date and time:
