Display data horizontally not vertically through VBA

Hi,

I have built a macro which loops through data from one sheet ("Sheet1") to build a URL (it's an API for the web analytics tool Webtrends). The macro then loads data from the API into a new sheet "display". Each dataset has the same 4 headers: Time Period, Page, Title, Page Views.

My issue is that the looped data is being displayed along columns (horizontally), but I need the data to display row after row (vertically).

The result I want is just 4 columns being filled with hundreds of rows of data, as opposed to hundreds of columns being filled with just a couple of rows of data. Transposing seems to just paste everything under one column.

Here is my code:

Please Login or Register  to view this content.

Can any body see why in this code my data is looping through columns as opposed through rows?

Thanks in advance!

Hello webanalytics1,

Welcome to the Forum!

I think I understand what you are saying. To be sure, can you post an example of the output?

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi Alan, thanks for reaching out too.

I have attached a sample of this macro, and the Macro is 'ConcatTestSampleVersion'. I used some API from the internet -http://wefeelfine.org/api.html (as my data is proprietary and requires login credentials).

I created a new sheet titled 'After' to show you how I want the data to appear (the example content is from We Feel Fine API).

The VBA code is the same, I've just replaced the URL: Sub ConcatTestSampleVersion()

Please Login or Register  to view this content.

Hello webanalytics1,

From the workbook, it appears you are importing only text. If that is the case, another method can be used to import the web table data, provided the page layout is the same for each web page.

Can you provide me the URL you are using and some data to concatenate to it?

Hello webanalytics1,

A VBA web query will return the data from its source as it is arranged in the table. Since your data is being flipped horizontally, the API you are using might be the problem. Have you checked your API code to be sure all variables and arguments are correct?

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)