Steve Thomson
New Member
Members
Forum Posts: 1
Member Since:
April 5, 2021
April 5, 2021
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Shaun Dunn
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —