Hello Community,
I have a raw data in which displays as merged cells and several headings within one column.
Here is what I have
I have been attempting to use If with vlookup and hlookup to accomplish this by using the Key as the unique identifier and then hlookup for either "Days" or "Hours".
My goal is to setup the table and be able to refresh it when I get a new data dump. All ideas are welcomed.
Thank you in advance!
I have a raw data in which displays as merged cells and several headings within one column.
Here is what I have
Key | Text | Repair Time |
123 | Job 1 | Days |
1 | ||
Hours | ||
3 | ||
234 | Job 2 | Days |
0 | ||
Hours | ||
4 |
I have been attempting to use If with vlookup and hlookup to accomplish this by using the Key as the unique identifier and then hlookup for either "Days" or "Hours".
Key | Text | Days | Hours |
123 | Job 1 | 1 | 3 |
234 | Job 2 | 0 | 4 |
My goal is to setup the table and be able to refresh it when I get a new data dump. All ideas are welcomed.
Thank you in advance!