Share via

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,944 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.
508 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  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,906 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