Forum Discussion

brad58's avatar
brad58
Regular Visitor
7 years ago

Merge Tables into aligned row

Hi all,   I've managed to get the following code to collate all my information into the same table (three different tables picked up), however when outputting the data it creates a new row, for eac...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Does this help?  You may download my file from here.

 

brad58's avatar
brad58
Regular Visitor
7 years ago

Hi Ashish,

 

Can you Transpose the data to have the Headers across the top, and the data underneath it (i.e. row 1 = Headers, row 2 = data).

I downloaded your sheet then and did that but had the same issue with the tables not lining up by row, as there are null values in the column headers where the other tables dont have data for it.

 

Link to file I've completed here

 

Ive included 3 example linkes in Sheet 3 that eventually I'd turn into a table, and then have the powerquery go through every link and return the data we have listed.

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    I do not understand your requirement.  Show me the exact result you want.  Also, that link requires signing in.

    • brad58's avatar
      brad58
      Regular Visitor
      7 years ago
      Hi Ashish,

      I basically want your result but transposed so headers are across the columns, and data in the row beneath.
      My problem is the data comes out with a row for each table result and not all three tables in the one row.
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        Right click on the Append Query > Edit.  Select both columns and go to Transform > Transpose.  Then Promote the Headers.