Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I need help. I need to divide every 4 columns into multiple rows. I have attached an example. For instance I have 8 columns, I need that to be divided every 4 columns, meaning I now have 2 rows with 4 columns each. I have a large excel sheet that needs splitting. Is there a code or a shortcut for this? Thank you in advance!
Solved! Go to Solution.
Should be no problem. If it's slow it's problably because something is wrong.
Note: the column names should be the same and in the same order.
Example
-A,B,C,D-
UNION/Append
-E as A, F as B, G as C, H as D-
Hi,
If there is a fixed amount of columns, you can just divide them in PQ in separate tables.
Then do a UNION (Append) and filter the headers out.
How do I divide them in PQ in separate tables? Sorry, I'm quite new to this.
Go to PQ
Duplicate the table
First table remove column 5-8
Second table remove column 1-4
Append first table with second table
Does this work on non-numerical characters? Instead of numbers, the data on the cells are links/urls
Yes, doesn't make a differance
Is this feasible for around 62,000 links? I'm having a hard time appending though because it says null
Should be no problem. If it's slow it's problably because something is wrong.
Note: the column names should be the same and in the same order.
Example
-A,B,C,D-
UNION/Append
-E as A, F as B, G as C, H as D-
User | Count |
---|---|
115 | |
95 | |
87 | |
76 | |
65 |
User | Count |
---|---|
138 | |
113 | |
110 | |
98 | |
93 |