Hi
I have a data table like the following:
submission id service name person type
1 service a bob adult
2 service b joe adult
3 service c sam child
4 service c ella child
5 service a rob adult
6 service b tim child
7 service c william adult
8 service c harry adult
9 service a bella adult
10 service b paul child
I want to transpose the data so the the data in the service column become the column headings and show the data from the other fields below... so service a would look like
service A
submission id name person type
1 bob adult
5 rob adult
9 bella adult
Ideally the services would appear in the same row with duplicated sets of columns for the other data
service A service b service c
submission id name person type submission id name person type submission id name person type
1 bob adult 2 joe adult 3 sam child
5 rob adult 6 tim child 4 ella child
9 bella adult 10 paul child 7 william adult
8 harry adult
How can I do this in power query M not Dax? I think it should be relatively simple but I can't work it out.
