How to Split A Single Row with Multiple Columns into Multiple Rows every certain value?

[hellohahaha819]

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!

[PVO3]

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.

[hellohahaha819]

How do I divide them in PQ in separate tables? Sorry, I'm quite new to this.

[PVO3]

Go to PQ

Duplicate the table

First table remove column 5-8

Second table remove column 1-4

Append first table with second table

[hellohahaha819]

Does this work on non-numerical characters? Instead of numbers, the data on the cells are links/urls

[PVO3]

Yes, doesn't make a differance

[hellohahaha819]

Is this feasible for around 62,000 links? I'm having a hard time appending though because it says null

[PVO3 · Accepted 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-