Hello,
I’m struggling with the logic/approach on this one.
I have a spreadsheet of fuel filters.
So in the spreadsheet, it looks kind of like this:
Unit#/Fuel 1/Fuel2/Air 1/Air2
12/abc123/abc223/airf123/airf124
13/abc123/abc212/airf123/airf124
I want to create output data that looks something like this:
Unit/Filter Class/Filter Number
12/Fuel Filter/abc123
12/Fuel Filter/abc223
12/Air Filter/airf123
13/Fuel Filter/abc123
13/Fuel Filter/abc212
Hopefully this makes sense.
Any thoughts on an approach, or some transformers I should work with?
Cheers!