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
Helper IVHi@amitchandak, Thank you for your respone. The suggestion only deals with the first half of my question.
The data cannot refresh/import if the number of columns in import changes i.e. I had 10 users and now I only have 6 users. Furthermore, User column positions might have changed i.e. I might have user 2 in the fifth column instead of user 1.
Helper IVOnly 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