Forum Discussion
Merge Tables into aligned row
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.
Super UserHi,
I do not understand your requirement. Show me the exact result you want. Also, that link requires signing in.
- 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
Hi,
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.