https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker Ka4ra Tracker Sat, 19 Sep 2026 18:11:01 GMT 2026-09-19T18:11:01Z https://community.fabric.microsoft.com/t5/Desktop/How-to-change-data-pivot-Group/m-p/3644706#M1192946 <P>I want to change the data format.</P><P>&nbsp;</P><P>Below is sample data. Data has a same ID, Value but Col1 to Col7 some have data and some do not.</P><P>I'm doing data transformation in Power BI, but I don't know what to do.&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>VALUE</TD><TD>Col1</TD><TD>Col2</TD><TD>Col3</TD><TD>Col4</TD><TD>Col5</TD><TD>Col6</TD><TD>Col7</TD></TR><TR><TD>23-01-01 2:40 PM</TD><TD>AAAAA3</TD><TD>20</TD><TD>null</TD><TD>2</TD><TD>25</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-01 2:40 PM</TD><TD>AAAAA3</TD><TD>20</TD><TD>15</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>20</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-01 2:40 PM</TD><TD>AAAAA3</TD><TD>20</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>52</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-02 12:10 PM</TD><TD>AVSV2</TD><TD>49</TD><TD>10</TD><TD>21</TD><TD>null</TD><TD>26</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-02 12:10 PM</TD><TD>AVSV2</TD><TD>49</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-02 12:10 PM</TD><TD>AVSV2</TD><TD>49</TD><TD>null</TD><TD>null</TD><TD>0.1</TD><TD>null</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>I want to change the format data look like below.</P><P>I would like to put the data of each column matching the ID into one ID row for each column.</P><TABLE><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>VALUE</TD><TD>Col1</TD><TD>Col2</TD><TD>Col3</TD><TD>Col4</TD><TD>Col5</TD><TD>Col6</TD><TD>Col7</TD></TR><TR><TD>23-01-01 2:40 PM</TD><TD>AAAAA3</TD><TD>20</TD><TD>15</TD><TD>2</TD><TD>25</TD><TD>52</TD><TD>20</TD><TD>null</TD><TD>null</TD></TR><TR><TD>23-01-02 12:10 PM</TD><TD>AVSV2</TD><TD>49</TD><TD>10</TD><TD>21</TD><TD>0.1</TD><TD>26</TD><TD>null</TD><TD>null</TD><TD>null</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 18 Jan 2024 02:22:52 GMT https://community.fabric.microsoft.com/t5/Desktop/How-to-change-data-pivot-Group/m-p/3644706#M1192946 Ka4ra 2024-01-18T02:22:52Z