Forum Discussion
Solved
How can I create table from registration table
Hello, I have a table which contains registration data which then want to be able to convert it into another table of different format automatically or with minimal steps. For example, I have th...
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!