Should I use cross Tab tools?

Question

Hey guys,

Here I attached a filed that has some input and a desired output. My problem here is I thought that I should use cross tab tools to get the output. But the result is in a same rows as the figured below. SO, any idea how should I solved this problem?

Test.xlsx

KaneG · Accepted Answer

Hi @Syarifhidayat,

You will need to put a record Identifier for each record that will stay on it's own line