Hello All,

I'm trying to transform data in a table with duplicated ID's but with unique dates associated with the ID into a table which has created additional columns by transposing the records based on the date. Trying with group, index, pivot etc. but with no success. Please see attached excel spreadsheet for more details.

I have googled this and cannot find something which seems able to do this in Power query which would be of huge benefit. Does anyone have any ideas or is this above and beyond what power query can do.

Steve