como puedo transponer la mi data de filas a columnas

Daniel Josué Yañez Agurto 0 Reputation points
2023-04-25T21:44:21.7366667+00:00

Hola, necesito transponer filas a columnas usando dataflows siguiendo este ejemplo en excel: tengo esto: |name| daniel|jose|adrian| | -------- | -------- | -------- | -------- | | edad | 24|25|26| | sexo|M|M|M|

y lo quiero asi | name|edad|sexo| | -------- | -------- | -------- | |daniel |24 |M| |jose|25|M|

como lo puedo hacer?

TRANSLATION:

Hi, I need to transpose rows to columns using dataflows following this example in excel: I have this: |name| daniel|jose|adrian| | | -------- | -------- | -------- | -------- | age | 24|25|26| | gender|M|M|M|M|M| and I want it like this | name|age|sex| | -------- | -------- | -------- | -------- | |daniel |24 |M|jose|25|M| How can I do it?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,836 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
497 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,931 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. Emi Zhang-MSFT 23,191 Reputation points Microsoft Vendor
    2023-04-26T09:59:37.21+00:00

    Hi,

    In Excel you can use Power Query to transform data:

    Select the range- go to Data- From Table/Range- uncheck the option "My table has headers"- open Power Query editor: User's image

    Under Power Query editor- go to Transform- Transpose- under Transform tab- select Use First Row as headers: User's image

    Go to Home- Close & Load: User's image

    Hope the information is helpful.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments