Home

Multiple Rows Data into Single Coloum

Highlighted
HeartFragile
New Contributor

Dear Experts.

I have sequential Data in a Table. Need a Logic to have these Table date in one Single Coloum.

A2 B2 C2

A3 B3 C3

A4 B4 C4

 

Result in Coloum D to be as 

A2

B2

C2

A3

B3

C3

so on .......

Please advise. Attached Sample.

 

Expert Advise Please. Thanks in Advance.

3 Replies

Hi,

 

That could be done with Power Query - query your range, select all columns, unpivot them and land result into Excel worksheet.

 

Please check attached.

Thanks @Sergei Baklan. That Helped. 

Hi @HeartFragile, I Think you can you Synkronizer Excel Add-in. Using Synkronizer you Don't need to write any code or Excel formula, Just Download Synkronizer and add into Excel Add-in then and use it. 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies