This is the link to the challenge am facing.
This dataset are data coming from the web.
The data set has scattered rows of cells values instead of been in just one record by record basis.
The ids are also repeating as well which is not what i want.
I want all the ids inline with each records.
The date column will enable me sort the data in descending order so that i can get the latest entry.
The last entry can replace an entry preceding it ,since our organisation what an update to last records if necessary.
Now the challeng is i want to keep some nulls values,because some of this null values are values yet to be filled.if i pivot it i will lost their column values or headers.How do i keep it.
Thank you.
Hi Femco,
Please provide some sample data so we don't have to recreate it.
Please provide an example (image, table, workbook) of what you want your result to look like. A written description is open to misinterpretation.
Now the challenge is i want to keep some nulls values, because some of this null values are values yet to be filled. if i pivot it i will lost their column values or headers. How do i keep it.
Which null values? How do we know which ones you want to keep?
regards
Phil
@Phil thank you for your response, the dataset are data coming from the web with dates posted.
so what that mean,is that, dates column is sorted in descending order so that the last entry corresonding to same ID same Column names updates a data preceding it...
Note:The powerquery window wont allow me take a screenshot of the all columns with dates .
However, i have managed to screenshot major issues and expected solutions..
This link is the challenge i am facing... Challenge
This is what i want.........Solution
There are columns for continous assessment , exam ,total score and grade.(MATHEMATICS=>Abbreviated: camth ,exammth, mth and mthgrade respectively. ).(ENGLISH=>Abbreviate caeng,exameng,eng and enggrade respectively) .This dataset are imported from the web .The total score has been computed and grade of every students taken from the remote source already.
As they are loaded on powerquery, some column contains null because they are column yet to be filled. I dont what a suituation where some column(s) containing null are removed, because removing the null, means i will lost the column data....
If also, have a zero '0' values from the remote source, powerquery should allow it update records of same ID and columns to zero.
This is a very complicated task, i pray there is a solution to it.
Thank you.
Hi Femco,
Please provide some data to work with. If you have it in PQ then you can provide it in a workbook for me, rather than me having to type everything out.
Regards
Phil
@Phil, alright. Some of the data contain some sensitive information.
However,i have provided a workbook that suggest similiar challenge ,which can be downloaded from my drive.
Sheet 1 contains the challenge. Sheet 2 contains the solutions expected.
Thank you .
Still waiting for a working solution??
