Forum Discussion
How can I create table from registration table
Samirv PowerQuery would be the easiest. collect your data in a structured table, query it and unpivot the date columns and then create the three column table as you described. Attached an example.
Append some new data to the table in Sheet1. Table expands automatically.
Go to the Table1 tab, right-click anywhere inside the table and select refresh, or select "Refresh all" in the Data ribbon.
If you re new to PQ, this is a good place to start (though there are many sites providing similar tutorials).
Samirv PowerQuery would be the easiest. collect your data in a structured table, query it and unpivot the date columns and then create the three column table as you described. Attached an example.
Append some new data to the table in Sheet1. Table expands automatically.
Go to the Table1 tab, right-click anywhere inside the table and select refresh, or select "Refresh all" in the Data ribbon.
If you re new to PQ, this is a good place to start (though there are many sites providing similar tutorials).
Riny_van_Eekelen This response was perfect. Solves my issue exactly and learnt something new too! Thank you so much for your help.
Samirv Glad I could help!
Riny_van_Eekelen Thank you for this! I am going through this to learn a bit about powerquery to see if I can use this!
