Multiple Rows Data into Single Coloum

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 







so on .......

Please advise. Attached Sample.


Expert Advise Please. Thanks in Advance.

3 Replies



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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies