Transform data - Is it transpose??

[keiranwyllie]

Hi everyone, hoping someone can provide some guidance.

Essentially I have rows of data that contain dates of various course completions against staff (one staff member per row). I want to transform that data into columns but transpose doesn't seem to be the most appropriate way I can do this. I've looked at power query too and can't really reach my end state.

Below is an example of the original data and then the way I need it to look. You can see that I need to fill the IDs and Names down the column provided the Cse/Dates are associated with that staff member.

Any help is greatly appreciated.

Surname	First	ID	Phone	Company	Cse 1	Cse 2	Cse 3	Cse 4	Cse 5
Bloggs	Joe	12345	111222	A1	1/07/2021	12/03/2021	1/04/2021	29/07/2021	8/02/2021
Smith	Bob	12435	112233	A1	28/02/2021	3/03/2021	20/05/2021	16/02/2021	30/06/2021

ID	Name	Cse Name	Date
12345	Bloggs,Joe	Cse 1	1/07/2021
12345	Bloggs,Joe	Cse 2	12/03/2021
12345	Bloggs,Joe	Cse 3	1/04/2021
12345	Bloggs,Joe	Cse 4	29/07/2021
12345	Bloggs,Joe	Cse 5	8/02/2021
12435	Smith,Bob	Cse 1	28/02/2021
12435	Smith,Bob	Cse 2	3/03/2021
12435	Smith,Bob	Cse 3	20/05/2021
12435	Smith,Bob	Cse 4	16/02/2021
12435	Smith,Bob	Cse 5	30/06/2021

 

[keiranwyllie]

Thanks for the update and definitely let me know.
Also let me know if you want any of it explained.

As a quick follow-up, this worked perfectly. I was able to implement this into my live document with minimal changes and I have the outcome I'm after.

Once again, thanks heaps for your expertise.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.