Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Automate transpose every 5 rows into 5 columnsHow do it with Power Query?Automate transpose every 5 rows into 5 columns Hello, I want to transpose every 5 rows into 5 columns From this : into this : Is there any way to do it in one go ? Thank you! Data transpose automatically in excel Hello experts, I still learn how to do transpose in excel. Until now, I still do some of it manually I want change this table into this table Thanks !