Forum Discussion
How to Split A Single Row with Multiple Columns into Multiple Rows every certain value?
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!
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-
7 Replies
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
