+ Reply to Thread
Results 1 to 2 of 2

Arrange a column of data into a single row after combining multiple files from power query

  1. 03-13-2021, 10:06 PM #1
    zak_knight
    zak_knight is offline
    Registered User
    Join Date
    03-13-2021
    Location
    New york
    MS-Off Ver
    2016
    Posts
    1

    Exclamation Arrange a column of data into a single row after combining multiple files from power query

    Hello, I have multiple excel files in a folder. Each excel workbooks contain multiple sheets. I need to combine a particular column of a table from a particular sheet from all the workbooks in the folder and arrange them row wise. All the workbooks, worksheets and tables are identical. Using power query, I have managed to combine the data however, I can't arrange them row wise. I have attached a sample excel workbook image and I would like the data to be arranged in the following manner.

    |__A______|__B__|__C__|__D__|__E__|__F__|
    1|File1_name| 500 | 751 | 362 | 458 | 258 |
    2|File2_name| 234 | 254 | 458 | 447 | 457 |
    3|File3_name| 215 | 151 | 144 | 124 | 458 |
    4|File4_name| 124 | 598 | 125 | 587 | 125 |
    5|File5_name| 111 | 254 | 875 | 548 | 154 |

    File1_name.png
    Reply With QuoteRegister To Reply
  2. 03-18-2021, 01:06 PM #2
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Arrange a column of data into a single row after combining multiple files from power q

    Hello zak_knight and Welcome to Excel Forum.
    It may make it easier for someone to help if we were provided the .xlsx file from the combined data that was produced from Power Query.
    Instructions for uploading .xlsx files are given in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] multiple outputs from single power query
    By siddiqsh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2022, 03:05 AM
  2. [SOLVED] Power Query - Multiple Rankings by Single Group
    By arpod in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-12-2021, 09:37 PM
  3. Re-arrange Data & Insert blank row (Formula or Power Query?)
    By rahuleyes in forum Excel General
    Replies: 2
    Last Post: 02-12-2020, 09:34 AM
  4. Combining data from multiple files into one single file
    By KaranG in forum Excel General
    Replies: 1
    Last Post: 11-19-2018, 04:08 AM
  5. Combining multiple columns data into a single column
    By tmor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2016, 07:12 PM
  6. [SOLVED] Combining multiple columns of data into single column
    By dsklein85 in forum Excel General
    Replies: 6
    Last Post: 10-30-2012, 11:18 PM
  7. Read Files, Arrange and Transpose Data to Single Worksheet
    By SPIV in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2010, 07:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1