Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
hellohahaha819
New Member

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!299425197_621559142876056_7203874436676325951_n.jpg

1 ACCEPTED SOLUTION
PVO3
Impactful Individual
Impactful Individual

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-

View solution in original post

7 REPLIES 7
PVO3
Impactful Individual
Impactful Individual

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.

PVO3
Impactful Individual
Impactful Individual

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

PVO3
Impactful Individual
Impactful Individual

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

PVO3
Impactful Individual
Impactful Individual

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-

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.