Pivot repeating columns names in PQ

Hi

i do have a log file from one equipment. Short description. Many stations, each station has a number, Temperatur, Time,..
The log file is creating one row for the whole line.
At the beginning of the row is see the time go in and the time go out of the line, the flightbar number (=batch) and then each station used with the parameter (temperature, time,..) for each station.

The problem now is I want to analyse the data and get the data in a better way to do so. This means I need a table with the basic data for each Flightbar (time in, out, number, good and bad,,,) and then only one column for each of the stations (Stn;Set time;Time;Time down;Time up;Temp;Amp H with the corresponding values.
The columns in the new format should be:
Date;Date in;Date out;Flightbar number;Process number;Order number1;Part number1;Total area4;Following alarm exist:;Stn;Set time;Time;Time down;Time up;Temp;Amp H;

For each flight number i will have x rows according to the number of x stations used.

I thought I know PQ a bit but I am confused how to so this problem. I attached the example CSV file for a better understanding.

Any thoughts from here?

thanks a lot

Please provide the workbook containing your attempt at pivoting the data using PQ so that we can troubleshoot.

OK, well, sorry, I'm not going to do this for you. The data is a complete mess and it would take hours for me to first work out what's what and then work out how to process it. Don't have the time for that - sorry.

Thank you for this - the fact that you have made an effort makes a big difference. I'll have another look, but I suspect it will be one of the forum members who is better at PQ than I am that will solve this.

Please try

Please Login or Register  to view this content.

Hello,

thanks a lot, nearly perfect. just the timing is mixed up, i will try to explain, just need some time to figure out how to describe

Integer-Divided is the number to keep the same number to stay in the same row after Pivot column.

There are neater ways to do this using Table.Group

Please Login or Register  to view this content.