Forum Discussion
Unstructured data taking values from one record and combining those values with other records.
There are quite a few steps to doing this, but in overview:
1. Add a column which is 1 for "AAA,time,..." rows and 0 otherwise
2. Do a running total on this column. Call this new column DateTimeID. Advice on running totals: https://gorilla.bi/power-query/running-total/
All rows which relate to the same DateTime (AAA-time, AAA-date, and CPU...) should now all have the same DateTimeID
3. Create 3 new tables in Power Query by referencing where we've got to so far. Disable data-load and make no further changes to the table we're referencing.
3.1 Your first new table is your time table. Filter only to AAA-time rows. Exclude all columns except Time and DateTimeID. Disable data-load.
3.2 Your second new table is your date table. Filter only to AAA-date rows. Exclude all columns except Date and DateTimeID. Disable data-load.
3.3 Your third new table is your CPU table. Filter only to CPU... rows. Use DateTimeID to join in Date and Time from steps 3.1 and 3.2.
Let me know if you get stuck on any step & I will provide more detail. I have assumed you are somewhat familiar with Power Query already.