How to transform data using Date/Time as unique identifier

[Ro_Mr_B]

Just started learning the ropes with excel.

I have some data that I pull from an SQL database and it looks like the following:

I'd like to use that data in a seperate sheet in a table with the following headers:

Date and Time

RFID #

Product Master

Description

Waste Trim Height

As you can possibly see, I'd like the use the Date/Time as an identifier that groups the information, but I'm not sure where to go with this, what functions to use.

The 'Product Master' and 'Description' columns I will be using a VLOOKUP to another sheet, they can be ignored for this case.

I'm not looking for anyone to write me a full answer, just a point in the right direction will be greatly appreciated!

 

[Kerryx]

Power query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Tag", type text}, {"Val", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Tag]), "Tag", "Val", List.Sum)
in
    #"Pivoted Column"

Book1
	A	B	C	D	E	F	G
1	Date	Tag	Val		Date	RFID#	WTH
2	28/07/2023 03:17	RFID#	451		28/07/2023 03:03	423	2456
3	28/07/2023 03:17	WTH	2455		28/07/2023 03:17	451	2455
4	28/07/2023 03:03	RFID#	423		28/07/2023 04:15	427	2466
5	28/07/2023 03:03	WTH	2456
6	28/07/2023 04:15	RFID#	427
7	28/07/2023 04:15	WTH	2466
Sheet1

 

[Ro_Mr_B]

Power query
View attachment 96130

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"Tag", type text}, {"Val", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Tag]), "Tag", "Val", List.Sum)
in
    #"Pivoted Column"

Book1
	A	B	C	D	E	F	G
1	Date	Tag	Val		Date	RFID#	WTH
2	28/07/2023 03:17	RFID#	451		28/07/2023 03:03	423	2456
3	28/07/2023 03:17	WTH	2455		28/07/2023 03:17	451	2455
4	28/07/2023 03:03	RFID#	423		28/07/2023 04:15	427	2466
5	28/07/2023 03:03	WTH	2456
6	28/07/2023 04:15	RFID#	427
7	28/07/2023 04:15	WTH	2466
Sheet1

This looks spot on! I'll give it a whirl Monday, many thanks.