•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query Ordering .csv files in rows instead of columns (left to right instead of top to bottom) while maintaining table format.
Our take
If you're looking to streamline the process of merging over 100 CSV files using Power Query for your university assignment, you're not alone. Many users encounter challenges when attempting to reorder data from a vertical to a horizontal layout without losing the integrity of their table format. While transposing data can sometimes seem like the solution, it may not achieve the desired effect.
I'm quite new to power query and have 100+ .csv files I need to merge into excel for a uni assignment. I have done and know how to do it manually, however over 100 is too many and would take me hours, hence why I want to use power query.
I am aware that you can transpose all the data, turning columns into rows and vice-versa, but I do not want to swap the columns and rows, I would just like the tables to be ordered left to right maintaining row and column format. I tried transposing after transforming but before combining the files, however it seems it will only let you expand by column.
Any Help would be much appreciated :)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to merge tables from different files on one single excelhello! I'm no Excel connosieur, so I'm turning to this subreddit for some help! I have 12 files on my computer (one for each month of the year 2025) who each contain between 10 to 12 Excel documents. In total, I have approximately 132 Excel books that I need to merge into one single Excel. All of these Excel files have the same table format, except for maybe 5 that contain the same information as the rest. The rows, instead of being in the same order as the others, are mixed up. I've tried using Power Query, but half of the Excel files I import come up empty/only bring half of the information. Does anyone have any recommendations/YouTube video tutorials, or some tips/tricks to tackle this as quickly as possible? I'm sure anything is faster than just copying and pasting everything manually. Thank you for reading!! submitted by /u/mirapxoxo [link] [comments]
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
Tagged with
#rows.com#Excel alternatives for data analysis#generative AI for data analysis#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#row zero#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Power Query#CSV files#merge#Excel