Create a lust form a Pivot table

Hi tried to see if this has been answered before but cannot find anything.

I have a list of data, that has unique identifier with date and amounts, there are sometomes more than 1 amount for each date.

I can pivot the data to give me the Unique Identifier as the row label and the Date as the column header with the amounts as the values, with those with the same unique identifier and date added together.

I then want to sumarrise it as a list with the unique Identifier - Date - total amount.

Have a very basic VBA knowledge.

Any suggestions appreicated.

That gives me exactly what I am looking for, thanks