Forum Discussion
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...
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.
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
Super User
Super UserHi,
Right click on the Append Query > Edit. Select both columns and go to Transform > Transpose. Then Promote the Headers.
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-msftCommunity Support
Hi brad58
First i need to confirm requirements with you
your expected output should be:
Right?
Best Regards
Maggie