Share via

How to split a table în Power Query

Iulian Alin Chiru 20 Reputation points
2023-12-22T08:23:08.18+00:00

Hi,

I'm new to using Power Query and I have this task, to split a bigger table into smaller ones then append them. How can one expert in PQ would do this task?

I have already done this task but in the simplest way and it involves 36 columns from Jan to the right and +50k rows and my laptop needs some serious pushup when hitting the refresh button...

Thank you for your ideas!

The table is like this:

Info1 Task1 Individ1 Jan Feb Mar ....

aaaa mmm nnnn 1 2 3

bbb ccccc dddd 4 5 6

And I need to obtain somethink like

aaaa mmm nnnn 1

bbb ccccc dddd 4

aaaa mmm nnnn 2

bbb ccccc dddd 5

aaaa mmm nnnn 3

bbb ccccc dddd 6

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2023-12-25T01:53:12.11+00:00

    Hi,

    Try this method:

    1. Select the Range- go to Data- From Table/Range- check the option "MY table has headers":
      User's image
    2. Open Power Query Editor- select the Column Jan, Feb and Mar- go to Transform- Unpivot Columns:
      User's image
    3. Select column Attribute- Right click and Remove the column- go to Home and Close & Load:
      User's image
    4. 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.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.