= Unpivot Columns = '''Unpivot Columns''' is a table transformation available in the [[Excel/PowerQuery|Power Query editor]]. <> ---- == Usage == Given a table like the following in the [[Excel/PowerQuery|Power Query editor]]: ||'''id'''||'''interaction1'''||'''interaction2'''||'''interaction3'''|| ||1 ||10 ||15 ||17 || ||2 ||10 ||12 ||null || ||3 ||12 ||null ||null || ||4 ||13 ||17 ||null || The table can be transformed into a tall list of interactions by selecting the relevant columns and selecting '''Transform''' > '''Unpivot Columns'''. This modifies the table in-place into: ||'''id'''||'''Attribute'''||'''Value'''|| ||1 ||interaction1 ||10 || ||1 ||interaction2 ||15 || ||1 ||interaction3 ||17 || ||2 ||interaction1 ||10 || ||2 ||interaction2 ||12 || ||3 ||interaction1 ||12 || ||4 ||interaction1 ||13 || ||4 ||interaction2 ||17 || ---- CategoryRicottone