Hi,
some of the source data display in the form (see attached first worksheet) that is not unique, row 2 - X is actually the sub-records as the row 1 etc, is there any way to use Power Query (hopefully less M coding) to transform into the unique columns (see 2nd woirksheet)
Of course we can use reference to duplicate a lot of queries and each one delete the bottom rows (before that got to find out the number of rows to delete), that will be tedious if the tables are huge and consists a lot of sub tables within
Attached mockup I only put in two sub-tables
Thank you in advanced
Hi Chris,
Please see attached.
Mynda
Hi Mynda , that was super fast, thanks
is there any quick way to break all these sub-tables into different queries, i.e. Total Citizen one query, Total Maie Citizen one query and so on
Hi Chris,
I'm not sure why you'd want to separate the data, but I'd be inclined to use PivotTables to extract the data (first add back the column that classifies the rows into Total Citizen etc.).
Otherwise, if you need it at the query level, then duplicate the query and apply a filter. Rinse and repeat for other sub-tables.
Mynda
Hi Mynda,
ok thanks for your recommendation, I would unpivot and import to Qlik Sense to visualize using QS filter
Thank you !
