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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.