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,

 

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.

     

    • brad58's avatar
      brad58
      Regular Visitor
      7 years ago

      Hi,

       

      Ok thats the format I want it in, but now I want to be able to paste a list of URL's that the query will run through and add the data from those 3 tables into the one combined table below each other.

       

      Hopefully this link works, as this is what I had done previously with this file being your with the latest transposing, and this file being the original one I did with the row errors.

       

      Let me know if those links don't work I'm uploading into Dropbox.

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi brad58

        First i need to confirm requirements with you

        your expected output should be:

         

        Right?

         

        Best Regards

        Maggie