Should I use cross Tab tools?

[Syarifhidayat]

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?

[KaneG · Accepted solution]

Hi @Syarifhidayat,

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

[ggruccio]

Hi,

This should work for you...(please see the attached)...provided the same pattern of Quantity/Rate repeats through your full data set.