Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Mapping columns

Hi,   I have data in a sheet with column names Date Facebook Fans Twitter Messages Tweets FB Posts Twitter followers FB followers   now I want to create a new table with columns SM platfo...
Need Help
Show and Tell
  • petrovnikitamai's avatar
    petrovnikitamai
    7 years ago

    Try to change your main table with unpivot table function in power query.

    U get this:

    After this u can create relationship between your tables by Attribute column.

petrovnikitamai's avatar
petrovnikitamai
Icon for Resolver V rankResolver V
7 years ago

Try to change your main table with unpivot table function in power query.

U get this:

After this u can create relationship between your tables by Attribute column.