I am not sure if this can be done in Power Query (I am using Power BI). I am looking to create some new rows based on the existing data. It's almost like doing a bit of an unpivot but to an existing column and appending some info. Here is the data I have:
Here is what I am trying to accomplish (in order to do some compares to the source system):
Thanks, that does get me halfway there. I guess once I am there, I can create a new column where I can derive what I ultimately need. If the fieldid = field value then use field id otherwise concatenate fieldid + attribute.