Forum Discussion
Helper IVReplace Values Match Entire Cell Contents with Varying Column Numbers
Only need to use the below section of your suggestion with some tricks from the following video and it worked. BTW the video suggested to use Marix, but mine worked with table.
Select the first 4 columns, and use unpivot other columns, You will two columns attribute and value, in the value column replace N with null
Super UserHabibAdil , Select the first 4 columns, and use unpivot other columns, You will two columns attribute and value, in the value column replace N with null and then pivot the columns again with the aggregation option as MAX
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
HabibAdilThe questions is how to dynamically adjust my output table so when I refresh the data, the number of columns increase or decrease based on the data in csv file.